What are defaults? Is there a column to which a default
can't be bound?
Answers were Sorted based on User's Feedback
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 |
Answer / ram
We can set Getdate() function by default to time stamp columns
Is This Answer Correct ? | 4 Yes | 0 No |
What is a data collection table?
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?
Why do we partition data?
How can delete duplicate records in cte in sql server?
What is a coalesce function?
What does executeupdate return?
How do I determine how many instances of sql server are installed on a computer?
Define indexes?
What are the ways available in sql server to execute sql statements?
How to find the service pack installed? : sql server database administration
How to get the definition of a stored procedure back?