Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / swapna

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

How to convert a numeric expression from one data type to another?

0 Answers  

Why does sql studio use a single registered database repository? : sql server management studio

0 Answers  

What are the system database in sql server 2008?

0 Answers  

Explain contrast amongst grouped and non-bunched records?

0 Answers  

What is the difference between local table and global table

1 Answers   CarrizalSoft Technologies, Polaris,




How to integrate the ssrs reports in application?

0 Answers  

What are the different types of subquery?

0 Answers  

How to see existing views in ms sql server?

0 Answers  

What is an Index?

3 Answers   Yardi Software,

What is live lock and deadlock? what is Lock escalation?

2 Answers   Microsoft,

Explain different types of lock modes in sql server 2000?

0 Answers  

What is difference between commit and rollback when used in transactions?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories