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

Sanjeev Kumar10y ago

create table table1

(

statud bit

)

insert into table1

select 'true'

select * from table1

Vinay Singh10y ago

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 Srivastava10y ago

Hi,

Simply you can use bit datatype in sql or visit;

http://www.sqlusa.com/bestpractices/bitdatatype/

Nitin Sontakke10y ago

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 Gupta10y ago

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.