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
- 16959 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 code near application topology?
Why would you call update statistics?
Is mysql the same as sql server?
What is the recommended total size of your memory optimized tables?
what is checksum in sql server.........???
How to perform backup for certificates in sql server? : sql server security
what is sql server? : Sql server database administration
Explain alternate key, candidate key and composite key in sql server?
Can two tables share a primary key?
In which format does an image save in SQL Server database ?
Is it possible to have clustered index on separate drive from original table location?
What is the importance of three tier architecture?
what are user defined datatypes? : Sql server database administration
What is the meaning of sql server?
What triggers long term care?
