What are defaults? Is there a column to which a default
can't be bound?

Answers were Sorted based on User's Feedback



What are defaults? Is there a column to which a default can't be bound?..

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

What are defaults? Is there a column to which a default can't be bound?..

Answer / ram

We can set Getdate() function by default to time stamp columns

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is a data collection table?

0 Answers  


How many types of cursors are there in SQL Server?

5 Answers   247Customer, CarrizalSoft Technologies,


What are the different authentication modes in sql server? How can it be changed?

0 Answers  


Why do we partition data?

0 Answers  


How can delete duplicate records in cte in sql server?

0 Answers  






What is a coalesce function?

0 Answers  


What does executeupdate return?

0 Answers  


How do I determine how many instances of sql server are installed on a computer?

0 Answers  


Define indexes?

0 Answers  


What are the ways available in sql server to execute sql statements?

0 Answers  


How to find the service pack installed? : sql server database administration

0 Answers  


How to get the definition of a stored procedure back?

0 Answers  


Categories