what is bit data type? and what are the information that can
be stored inside a bit column?
- 2 Answers
- 3540 Views
- I also Faced
- E-Mail Answers
Answer Posted / meena kurade
Bit datatype is used to store boolean information like 1 or
0 (true or
false). Untill SQL Server 6.5 bit datatype could hold either
a 1 or 0
and there was no support for NULL. But from SQL Server 7.0
onwards,
bit datatype can represent a third state, which is NULL.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain differences between web edition and business edition?
Explain in brief about Microsoft SQL server?
How to implement service broker?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
What is a collation?
How to round a numeric value to a specific precision?
What is the process of normalising?
How to drop existing views from a database in ms sql server?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
Explain the difference between cross join and full outer join?
Characterize join and name diverse sorts of joins?
what is an extended stored procedure? : Sql server database administration
What is function of master database?
What is BLOCK statements in SQL?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
