Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 boolean equivalent datatype in sql server

Author  Topic 

Ranjit.ileni
Posting Yak Master

183 Posts

Posted - 2011-02-23 : 01:39:26
For storing true or false values in status coulmn in mytable

which datatype is preferable while creating mytable


--Ranjit

matty
Posting Yak Master

161 Posts

Posted - 2011-02-23 : 01:47:23
BIT
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-02-23 : 02:11:33
you might also want to make your bit column NOT NULL else there will be a possible of 3 state


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -