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
- 16482 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
Explain system views?
Name some of the open source software that you can use in alternative to SSR?
What are different types of raid configurations? : SQL Server Architecture
What is unpivot?
What are the differences between having and where clause.
What is the fastest way to permanently delete a 1 million row table named customers?
Which tcp/ip port does sql server run on? How can it be changed?
How to modify the underlying query of an existing view?
Explain what is dbcc?
Mention what are the core components of ssrs?
How to delete existing triggers using "drop trigger"?
What is a join in sql? What are the types of joins?
Explain how to maintain a fill factor in existing indexes?
Can a database be shrunk to 0 bytes, if not, why?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
