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 the Main Difference between ACCESS and SQL SERVER?
How to create a dml trigger using create trigger statements?
What are the 2 types of classifications of constraints in the sql server?
What is filter index?
Explain filtered indexes?
Give a example to search fr a string in all stored procedure in sql server.
How to truncate the log in sql server 2012? : sql server database administration
can SSRS reports Cache results?
How to select some specific rows from a table in ms sql server?
How to create a new table in a given schema?
What are the differences between local and global temporary tables?
How to disable a login name in ms sql server?
What are the kinds of subquery?
Difference between connected and disconnected database in .net with sql server?
how to overcome kernel isssues