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

How to create stored procedures with parameters in ms sql server?

526


Can we update data in a view?

601


What are the types of sql server?

521


What is the purpose of optimization?

544


what is unique and xaml nonclustered index

559






What is thr feature of change data capture?

508


What are the 2 types of classifications of constraints in the sql server?

587


What is difference between equi join and natural join?

543


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

533


What is the difference between varchar and nvarchar datatypes?

573


what does the automatic recovery do? : Sql server administration

538


What is it’s similarity with sql server?

143


What are the difference between “where” and “having” clause in sql server?

585


You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

243


What is normalization and denormalization in sql server?

539