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
 General SQL Server Forums
 New to SQL Server Programming
 Insert True/False into boolean field

Author  Topic 

Apples
Posting Yak Master

146 Posts

Posted - 2008-06-12 : 11:53:17
When I enter a a true or false value into a boolean field, what is the proper way to enter it? I'm using:

INSERT INTO tblTable (IsSomething)
VALUES (False)

I've heard that a better way is to use 1 and 0, or something.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-06-12 : 12:25:41
You need to enter either 1 or 0 and it may contain NULL also

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -