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 |
How to get the query of a table in sql server?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
What are Sql Reporting Services and analysis services? Can u Explain
How can you hide the sql server instances?
how do u find least salary in a table
Where do you find the default Index fill factor and how to change it?
How to use subqueries with the exists operators in ms sql server?
Give me any three differences between Truncate and Delete.
What is the maximum number of index per table?
what command is used to create a table by copying the structure of another table?
What are security principals used in sql server 2005?
Oracle (3253)
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)