just my 2ct:
Bit is context driven !
If your column name doesn't declare it by nature, you should document it well !
e.g. a column named "AreLightsOn" would by nature have a bit value 0 for NO (lights are not ON) and the other value (-1 or 1, depending on you sqlserver version) would be YES (lights are on)
A column named "Gender" would have to be documented which gender code would be used for male and which code for female.
Keep in mind a bit column can be NULL unless declared otherwise.
Up to 7 bit columns can be stored in a byte, but off course the first bit column will add a byte to your row length.
btw: There is no reason to shout at any forum !
In many cases if you don't get the answer you aimed for, or if the answers aren't what you would expect, chances are you malformed the question.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me