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

What is temporal data type?

0 Answers  

How to genrate automaticlly empid like gt001

4 Answers  

Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 Answers  

What is the sql profiler?

0 Answers  

How to display a past time in days, hours and minutes?

0 Answers  




What are group functions in query statements in ms sql server?

0 Answers  

What is an extended Stored Procedure?

1 Answers  

What happens if ntwdblib.dll is missing on your machine?

0 Answers  

How to check what was the last restore transaction LSN on Log-Shipping and Mirroring when we doesn't have a Monitor server and Witness server?

2 Answers   IBM,

What is the largest component inside a field?

0 Answers  

how to delete duplicate rows from table in sql server

12 Answers   HCL, UHG,

What is xml datatype?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories