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
How to create stored procedures with parameters in ms sql server?
Can we update data in a view?
What are the types of sql server?
What is the purpose of optimization?
what is unique and xaml nonclustered index
What is thr feature of change data capture?
What are the 2 types of classifications of constraints in the sql server?
What is difference between equi join and natural join?
You want to implement the one-to-one relationship while designing tables. How would you do it?
What is the difference between varchar and nvarchar datatypes?
what does the automatic recovery do? : Sql server administration
What is it’s similarity with sql server?
What are the difference between “where” and “having” clause in sql server?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
What is normalization and denormalization in sql server?