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 types of replication are supported in sql server? : Sql server database administration
What happens if null values are involved in bitwise operations?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
Do you know what are pages and extents? : SQL Server Architecture
What is row_number function?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
What are indexes in sql?
Explain following error properties?
What are the different types of sub-queries?
What are the five major components of a dbms?
What according to you is the difference between mysql and sql server performance?
What are the basic functions for master, msdb, model, tempdb and resource databases?
How to divide query output into multiple groups with the group by clause in ms sql server?
Is sql server free?
Is it important for a database administrator to understand the operating system and file access?