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

How do you run a trace?

515


Why is the need for data conversion transformations?

496


Can foreign key be deleted?

524


What is a not null constraint?

591


Explain the different index configurations a table can have?

500






What do you mean by table and field in sql?

550


What happens if null values are involved in string operations?

552


What is dbcc?

729


Does server sql treat char as a variable-length or fixed-length column?

578


Difference between uniqe index and uniqe constraint?

542


what exactly sql injuction.how to overcome.....

2035


What are various ways to enhance the ssrs report?

528


Which are the olap features?

544


What is a result set object returned by mssql_query()?

574


can a database be shrunk to 0 bytes, if not, why? : Sql server administration

600