Can we have more than one NULL in a column having unique
constraint?
Answer Posted / krishnaraj p n
UNIQUE constraints can accept NULL just once. If the
constraint is defined in a combination of fields, then
every field can accept NULL and can have some values on
them, as long as the combination values is unique.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is snapshot parameter in ssrs?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
Which are the new data types introduced in sql server 2008?
What are the commands used in DCL?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
What are views in ms sql server?
How to override dml statements with triggers?
What is the difference between for xml raw and for xml auto?
Give me any three differences between Truncate and Delete.
How optimize sql query with multiple joins in sql server?
How to convert character strings into numeric values?
What is primary key index?
What are scalar functions?
Can you edit the .rdl code associated with a linked report?
How to encrypt Strored Procedure in SQL SERVER?