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

If a column is an image value type, how you can compare column values? How can you use this column in join clause?

581


In which database can extended stored procedures be added?

525


Explain about network model?

580


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?

1982


What is normalization? Explain different levels of normalization?

59776






How is data stored in dbms?

514


Which four data types cannot be used as a return type from a user-defined function?

574


Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

1578


What are data modelling techniques?

514


What is DB Development software?

1607


What is dbms and its application?

546


explain detail about ftp in datastage?

1806


What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

582


How long can an error message be in raiseerror function?

540


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

550