Interested to Buy Any Domain ? << Click Here >> for more details...
Can we have more than one NULL in a column having unique
constraint?
- 12 Answers
- 16016 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 is dbcc?
Explain important index characteristics?
What are the recovery models in sql server 2000?
Can we insert data if clustered index is disabled?
what are defaults? : Sql server database administration
Do you know what is rank function?
What are the disadvantages of indexes?
What are transactions and its controls?
What is the data tier application?
How to use linked server?
How to download microsoft sql server 2005 express edition?
What is Command line parameters in PLSQL.?
Does sql server use java?
What is user defined datatypes and when you should go for them?
What are indexes in sql?
