what are default? Is there a column to which a default cant be
bound?
Answer Posted / sreejith s t
Default means giving some default value to column . If we
are not inserting any value to that column , default value
will be inserted .
Default cant be bound to identity and
timestamp columns .
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
What is for xml in sql server?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
How to enable/disable indexes?
What is inner join in sql server joins?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
What are partitioned views?
Can I run multiple instances of sql server 2000 at the same time on one computer?
Does union all remove duplicates?
How to create a scrollable cursor with the scroll option?
What is the security principal at the database level that represents your session?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What is the simplest way to create a new database in ms sql server?
What is data compression?
Why use sub query in sql server and list out types of sub queries?