Can we have more than one NULL in a column having unique
constraint?
Answer Posted / manoj pandey
No this is not possible... columns with Unique constraint
can only contain 1 null value/row.
@Manish... could you please try this:
create table #tempTable (id int, name varchar(50) unique)
insert into #tempTable
select 1, 'manoj' union
select 2, null union
select 3, null union
select 4, 'pandey'
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is mssql?
Can a database be shrunk with users active?
What are the different index configurations a table can have?
Tell me what is de-normalization and what are some of the examples of it?
Explain powershell included in sql server 2008?
What is BLOCK statements in SQL?
What is the difference between a unique key and primary key?
Does table partitioning improve performance?
What is 'write-ahead log' in sql server 2000 ?
How to insert multiple rows with one insert statement in ms sql server?
How connect excel to sql server?
Should you normalize audio?
What is meant by indexing files?
Is foreign key a primary key?
explain different types of cursors? : Sql server database administration