Can we have more than one NULL in a column having unique
constraint?
- 12 Answers
- 13745 Views
- 247Customer, I also Faced
- E-Mail Answers
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 are the steps you should follow to start sql server in single-user mode?
What are data files?
What is SQL Azure?
What are logical/boolean operations in ms sql server?
What are a scheduled jobs?
what changed between the previous version of sql server and the current version? : Sql server database administration
What is #table in sql server?
Define normalisation?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What is a view in sql?
what are the critical issues you have resloved in your company
What is server-level principal?
Explain what are sparse columns?
What is the difference between migration and upgradation in sql server?
What do you mean by acid?
