what are default? Is there a column to which a default cant be
bound?

Answer Posted / sreejith s t

Default means giving some default value to column . If we
are not inserting any value to that column , default value
will be inserted .

Default cant be bound to identity and
timestamp columns .

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

810


What do you understand by replication in sql server?

750


Is ssrs support other database except ms sql server?

104


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1763


To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

718






How is table type constraint applied to a table?

733


Explain encryption of entire databases without the need for application changes in sql server 2008?

768


How to get the definition of a stored procedure back?

710


how can u get last observation in an unknown dataset ?

2185


what are isolation levels? : Sql server database administration

659


What are data regions?

107


How to create a trigger for insert only?

764


What are the advantages of using stored procedures in sql server?

699


What are the default system databases in sql server 2000?

691


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1716