What is bit datatype and what's the information that can be
stored inside a bit column?

Answer Posted / sd

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 ?    9 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

2222


Explain about xml databases?

870


What are data modelling techniques?

758


Explain about the relational database?

847


Can an extended stored procedure be called from inside a user-defined function?

861


What is an application role and explain a scenario when you would use one?

805


Explain the rollup operator?

856


Explain the role of indexing in databases?

906


State the acid rules?

931


On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

785


You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

755


How is data stored in dbms?

735


Which data type cannot be used as a parameter in a udf?

782


Explain about relational operator join?

841


Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

1912