how to insert data valur in IsActive column in sql server

Posted by Shanky11 under ASP.NET on 3/23/2013 | Points: 10 | Views : 2466 | Status : [Member] | Replies : 8
how to insert data value in IsActive column in sql server
data type is bit of that column
actually my table is consist of columns
message id message, chapter, session,word,IsActive




Responses

Posted by: Prateekagra on: 3/23/2013 [Member] Starter | Points: 25

Up
0
Down
what is Inactive it is columns name or it is any property of table

Prateek Agarwal
DBA

Shanky11, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Shanky11 on: 3/23/2013 [Member] Starter | Points: 25

Up
0
Down
hi prateek
its IsActive column name data type bit

Shanky11, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Prateekagra on: 3/23/2013 [Member] Starter | Points: 25

Up
0
Down
then there is no issue to insert any int type values eg

insert into xyz values(1)

Prateek Agarwal
DBA

Shanky11, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Prateekagra on: 3/23/2013 [Member] Starter | Points: 25

Up
0
Down
hi Shanky

if you satisfy the answer then closed this closed mark as answered

Prateek Agarwal
DBA

Shanky11, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Shanky11 on: 3/23/2013 [Member] Starter | Points: 25

Up
0
Down
i have to add this by manual insertion not by query

Shanky11, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Prateekagra on: 3/23/2013 [Member] Starter | Points: 25

Up
0
Down
then you have right false or true in the column

Prateek Agarwal
DBA

Shanky11, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Shanky11 on: 3/23/2013 [Member] Starter | Points: 25

Up
0
Down
its showing error........................


Shanky11, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Prateekagra on: 3/23/2013 [Member] Starter | Points: 25

Up
0
Down
can you share the error message please and also let me know the structure of table and data you are trying to insert

which version of sql you are using

Prateek Agarwal
DBA

Shanky11, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response