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 what is lock escalation?
Can we use max in where clause?
How do you Implement SSIS Packages in your Project?
What is dml command?
Explain Capacity planning to create a database? and how to monitor it?
What is constraints and its types?
What is the difference between a "where" clause and a "having" clause?
What is the full form of dql?
How to round a numeric value to a specific precision?
Tell me what is difference between clustered and non clustered index?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
What is primary key and example?
What is the server name in sql server?
Explain SSRS Architecture?
How to grant a permission in ms sql server using "grant execute" statements?