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


Please Help Members By Posting Answers For Below Questions

Explain the cursor lock types?

750


What are logical database components? : SQL Server Architecture

661


What do you understand by sql server agent?

691


what authentication modes does sql server support? : Sql server database administration

720


How do I find information about the install locations for the various instances running on a computer?

771


How to enter comments in transact-sql statements?

720


What is an execution plan? When would you use it?

733


What is the difference between composite index and covering index?

690


How column data types are determined in a view?

689


What is the difference between createstatement and preparedstatement?

699


Can you explain important index characteristics?

694


How can I know what locks are running on which resource?

712


do you know how to configure db2 side of the application? : Sql server database administration

791


Explain security with sql azure?

171


What are sql dirty pages?

760