What are defaults? Is there a column to which a default
can't be bound?
Answer Posted / swapna
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 ? | 5 Yes | 1 No |
Post New Answer View All Answers
Explain the cursor lock types?
What are logical database components? : SQL Server Architecture
What do you understand by sql server agent?
what authentication modes does sql server support? : Sql server database administration
How do I find information about the install locations for the various instances running on a computer?
How to enter comments in transact-sql statements?
What is an execution plan? When would you use it?
What is the difference between composite index and covering index?
How column data types are determined in a view?
What is the difference between createstatement and preparedstatement?
Can you explain important index characteristics?
How can I know what locks are running on which resource?
do you know how to configure db2 side of the application? : Sql server database administration
Explain security with sql azure?
What are sql dirty pages?