What is bit datatype and what's the information that can be
stored inside a bit column?
Answer / 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 |
What are “lost updates”?
How to see the event list of an existing trigger using sys.trigger_events?
What is the sql server agent?
How to modify an existing stored procedure in ms sql server?
Determine when to use stored procedure to complete sql server tasks?
How to get the definition of a stored procedure back?
Explain the collation?
Which command is used for user defined error messages?
Do you know what is blocking?
What is the filtered index?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
Why I have to use stored procedures?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)