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.
| Author |
Topic |
|
simflex
Constraint Violating Yak Guru
327 Posts |
 Posted - 2013-07-31 : 12:17:54
|
Can someone please help with inserting values into a bit data type?
We have a checkbox on one of our forms.
If a user checks this box and clicks the Save button, we would like to have a value of 1 or True inserted into the table.
If however, the box is not checked, rather than inserting NULL, we would like to insert 0 or False.
Any idea how to solve this?
Thanks alot in advance
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2013-07-31 : 12:37:08
|
1 and 0 will evaluate as bit set and bit not set (true and false).
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-08-01 : 02:58:07
|
quote:
Originally posted by simflex
Can someone please help with inserting values into a bit data type?
We have a checkbox on one of our forms.
If a user checks this box and clicks the Save button, we would like to have a value of 1 or True inserted into the table.
If however, the box is not checked, rather than inserting NULL, we would like to insert 0 or False.
Any idea how to solve this?
Thanks alot in advance
Check the status of checbox (checkbox checked/not checked) in your front end application code and pass value as 1 or 0 to the database.
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
|
|
|
|
|
|
|
How to insert into a BIT datatype