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


Please Help Members By Posting Answers For Below Questions

Explain system rowset functions?

554


What is lock escalation? : sql server database administration

592


What is a virtual table in sql?

543


What are the advantages of using stored procedures in sql server?

504


How do you debug a procedure in sql server?

492






What do you understand by replication in sql server? Mention the different types of replication in sql server.

500


How can sql server instances be hidden? : sql server security

592


Give a example to search fr a string in all stored procedure in sql server.

529


what is spatial nonclustered index

536


Explain Reporting Life Cycle?

90


What are horizontal and vertical scaling?

144


What is a non-clustered index?

558


You want to use a perspective in an mdx query. How do you select the perspective?

157


What is ms sql server index?

560


You want to implement the many-to-many relationship while designing tables. How would you do it?

555