How to insert values(true/false or 0/1) in Sql Server 2008

Question

How to insert values(either true/false or 0/1) in Sql Server 2008. Thanks in advance

Sanjeev Kumar · Answer

create table table1 ( statud bit ) insert into table1 select 'true' select * from table1

Vinay Singh · Answer

Try the below link http://stackoverflow.com/questions/21073357/how-to-insert-bool-into-database http://stackoverflow.com/questions/22207238/how-to-send-boolean-value-to-an-insert-stored-procedure-in-sql-server

Bikesh Srivastava · Answer

Hi Simply you can use bit datatype in sql or visit; http://www.sqlusa.com/bestpractices/bitdatatype/

Nitin Sontakke · Answer

As Amit has already pointed out there is no native support of boolean data type in SQL Server. The nearest you get is bit which is incidently also nullable (if desired). You can mark it as a NOT NULL while creating a table for near perfect implementation of Boolean in C#.

Amit Gupta · Answer

Hi Asif You can use 'bit' datatype in sql server 'bit' is one of the integer data types in SQL Server. It can store the values 1 0 or NULL. It can also be used to store boolean values because TRUE is convertible to 1 and FALSE is convertible to 0.