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

Answer Posted / kalu

No, because Unique constraint accepts only one null value.

Is This Answer Correct ?    16 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

State the difference between union and union all?

515


What are the differences between stored procedure and view in sql server?

616


What is the default sql server instance name?

556


What is primary key and example?

500


How can I get data from a database on another server?

507






Should you normalize audio?

524


you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

538


What are different types of data sources?

488


What are logical/boolean operations in ms sql server?

537


What is the process of indexing?

508


What are “phantom rows”?

1238


What is the name of the system variable that returns the number of rows affected by a SQL statement?

565


what are the types of indexes? : Sql server database administration

592


What are exact numeric data types in ms sql server?

508


What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

602