path To SE

Boolean Values

Store Boolean Values in MS SQL Server

------------------------------------------------------

-- Boolean Values in MS SQL Server --

------------------------------------------------------

drop table Temp;

create table Temp(

Atr1 char(5) primary key,

Atr2 bit -- bit can be used to store boolean values

);

insert into Temp

values ('AA123','true');

insert into Temp

values ('BB234','false');

insert into Temp

values ('CC345',null);

select * from Temp;