Can we have more than one NULL in a column having unique
constraint?

Answer Posted / p.prabhu

No we cant have More than One Null in a column which is
having Unique Key Constraint. Because Unique Key Constraint
means having a value only once in the column.

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create a stored procedure with a statement block in ms sql server?

578


What are types of subqueries?

560


How to find the login name linked to a given user name?

536


What is the full meaning of dml?

534


What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

553






Explain go command in sql server?

549


what is bit datatype? : Sql server database administration

510


Mention what are the different types of ssrs reports?

100


How to change the data type of an existing column with "alter table" statements in ms sql server?

534


List some advantages and disadvantages of stored procedure?

575


Explain the creation and execution of a user-defined function in the sql server?

590


If a stored procedure is taking a table data type, how it looks?

5810


Can group functions be mixed with non-group selection fields in ms sql server?

549


What are tables in sql server?

539


What is Dependency Injection and provide example?

621