what is bit data type? and what are the information that can
be stored inside a bit column?
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
How to sort query output in descending order in ms sql server?
What command is used to rename the database?
What are the disadvantages of primary key and foreign key in SQL?
What are different types of raid configurations? : SQL Server Architecture
what is create database syntax? : Sql server database administration
What functions can a view be used to performed?
How connect excel to sql server?
What is order of B+tree?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What are the encryption mechanisms in sql server?
How to filter records of table in SQL SERVER?
What does the on delete cascade option do?
How to create an inline table-valued function?
How many levels of sp nesting is possible?
What is the correct order of the logical query processing phases?