What is bit datatype and what's the information that can be
stored inside a bit column?
Answer Posted / swapna
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 ? | 8 Yes | 1 No |
Post New Answer View All Answers
Write a SQL queries on Self Join and Inner Join.
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
What happens if null values are involved in boolean operations?
Which are the important points to note when multilanguage data is stored in a table?
What is the temp table?
How can sql server instances be hidden? : sql server security
How do you migrate data from mssql server to azure?
What is self contained multi valued query?
How to create a view with data from multiple tables?
What is purpose of normalization?
When would you prefer to have a minimum number of indexes?
What do you understand by integration services in sql server?
Can you explain the disadvantages/limitation of the cursor?