What are defaults? Is there a column to which a default
can't be bound?
Answer Posted / leena
A default is a value that will be used by a column, if no
value is supplied to that column while inserting data.
IDENTITY columns and timestamp columns can't have defaults
bound to them
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Who are naive users?
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
Explain about query and reporting.
What are the three types of database design?
What are the main phases of database development?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
fact table and dimension table containg one to many relationship or many to one relastionship
How is data stored in dbms?
How to read and create .LDC data files which are used by linguatic dictionary.
What is the maximum length of an extended property?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
How you can make a parameterized view?
What are the key features of dbms?