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
Explain system rowset functions?
What is lock escalation? : sql server database administration
What is a virtual table in sql?
What are the advantages of using stored procedures in sql server?
How do you debug a procedure in sql server?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
How can sql server instances be hidden? : sql server security
Give a example to search fr a string in all stored procedure in sql server.
what is spatial nonclustered index
Explain Reporting Life Cycle?
What are horizontal and vertical scaling?
What is a non-clustered index?
You want to use a perspective in an mdx query. How do you select the perspective?
What is ms sql server index?
You want to implement the many-to-many relationship while designing tables. How would you do it?