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
What do you understand by triggers and mention the different types of it?
How to get the definition of a user defined function back?
What are the drawbacks of reporting in ssrs?
What protocol does sql server use?
What is the contrast between sql and mysql?
What is data block and how to define data block size?
What is the difference between Normalization and De-normalization?
Why we use functions in sql server?
Do you know what are acid properties of transaction?
What are the properties and different types of sub-queries?
How to execute a stored procedure in ms sql server?
Does union all remove duplicates?
Why should one not prefix user stored procedures with ‘sp_’?
What is temporal data type?
how would you improve etl (extract, transform, load) throughput?