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

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / ramesh

Float
Binary Data

Is This Answer Correct ?    3 Yes 3 No

Post New Answer

More DB Development Interview Questions

How can I detect whether a given connection is blocked?

0 Answers  


Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

0 Answers  


How to combine two function together?

0 Answers  


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

0 Answers  


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?

0 Answers  


explain detail about ftp in datastage?

0 Answers   IBM,


How can you log an error to the server event log from a stored procedure?

0 Answers  


1. Using the XML Document below, with the URI “recipe.xml” define the following queries in XQuery: a.) Give the names of all breakfast in the menu. b.) Select breakfasts that have price lower than $7.00? <?xml version="1.0"?> <breakfast_menu> <food> <name>Belgian Waffles</name> <price>$5.95</price> <description> two of our famous Belgian Waffles with plenty of real maple syrup </description> <calories>650</calories> </food> <food> <name>Strawberry Belgian Waffles</name> <price>$7.95</price> <description> light Belgian waffles covered with strawberries and whipped cream </description> <calories>900</calories> </food> <food> <name>Berry-Berry Belgian Waffles</name> <price>$8.95</price> <description> light Belgian waffles covered with an assortment of fresh berries and whipped cream </description> <calories>900</calories> </food> <food> <name>French Toast</name> <price>$4.50</price> <description> thick slices made from our homemade sourdough bread </description> <calories>600</calories> </food> <food> <name>Homestyle Breakfast</name> <price>$6.95</price> <description> two eggs, bacon or sausage, toast, and our ever-popular hash browns </description> <calories>950</calories> </food> </breakfast_menu>

0 Answers  


Write short notes on manual refreshes.

0 Answers  


What are the key features of dbms?

0 Answers  


When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).

0 Answers  


fact table and dimension table containg one to many relationship or many to one relastionship

0 Answers  


Categories