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
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?
Explain about xml databases?
What are data modelling techniques?
Explain about the relational database?
Can an extended stored procedure be called from inside a user-defined function?
What is an application role and explain a scenario when you would use one?
Explain the rollup operator?
Explain the role of indexing in databases?
State the acid rules?
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?
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?
How is data stored in dbms?
Which data type cannot be used as a parameter in a udf?
Explain about relational operator join?
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