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
What are the constraints on severity level in raiseerror?
Where is dbms used?
Explain what a database is?
How to use timestamp datatypes
How would you design a database for an online site, which would average a million hits a day?
Explain the cube operator?
Explain the role of indexing in databases?
Who are naive users?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
How you can make a parameterized view?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
Can an extended stored procedure be called from inside a user-defined function?
What is a database development?
What is data modeling with example?
Explain about query and reporting.