how to insert data valur in IsActive column in sql server

Posted by Shanky11 under ASP.NET on 3/23/2013 | Points: 10 | Views : 2564 | Status : [Member] | Replies : 8

Write New Post |

Search Forums | Answered

Answered

Resolved Posts |

Un Answered Posts |

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	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

0	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

0	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

0	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

0	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

0	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

0	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

Latest Posts