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

Do comments need to go in a special place in sql server 2005?

0 Answers  

Explain Active/Active and Active/Passive cluster configurations?

1 Answers  

How to disconnect from a sql server using mssql_close()?

0 Answers  

Describe in brief databases and sql server databases architecture.

0 Answers  

What is bcp? When does it used?

0 Answers  




Do you know the isolation level that sql server support?

0 Answers  

What does <> symbol mean?

0 Answers  

Describe in brief system database.

0 Answers  

Is foreign key a primary key?

0 Answers  

What are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

0 Answers  

How many types of triggers are there?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories