开发者

representing boolean data in sql server

i am using asp.net application to enter and view data in sql server database.

i am not sure what data type to use in sql server to allow booleans?

when entering data into the database the users will be clicking on a check box to signify true/false.

  1. how do i implement bools with sql server?
  2. how do i give the ability to th开发者_开发问答e user in formview to enter true/false?


As the others said, you can use BIT datatype.

However, be warned that if you put BIT into a table, and you want only binary values, disable NULL.

If you allow NULL in a bit field it will actually be trinary and allow three values.


Use the BIT column. In your form just provide a radio button or checkbox. Here is a helpful link of Sql Data Types compared to .NET types: http://msdn.microsoft.com/en-us/library/cc716729.aspx


Use the bit datatype. I would use a checkbox in the gui. If it is not checked then the bit value should be 0, else 1.


One word: bit! (now I am just padding the answer because it is too short)

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜