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



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

Answer / 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

More SQL Server Interview Questions

What is compression - row-level and page-level compression?

0 Answers  


Difference between Function and Stored Procedure?

9 Answers   C1 India, NA,


Tell me what do you mean by an execution plan? Why is it used? How would you view it?

0 Answers  


Please explain go command in sql server?

0 Answers  


How to list all stored procedures in the current database using ms sql server?

0 Answers  






When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

0 Answers  


What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,


what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  


How does a profiler work?

0 Answers  


Data table as parameter in sql server?

0 Answers  


What is the sql case statement used for?

0 Answers  


can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com

28 Answers   IBM, Symphony,


Categories