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
- 16515 Views
- 247Customer, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kalu
No, because Unique constraint accepts only one null value.
| Is This Answer Correct ? | 16 Yes | 3 No |
Answer / p.prabhu
No we cant have More than One Null in a column which is
having Unique Key Constraint. Because Unique Key Constraint
means having a value only once in the column.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / santhoshkumar.k
No we can not have that option in sql server
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / krishnaraj p n
UNIQUE constraints can accept NULL just once. If the
constraint is defined in a combination of fields, then
every field can accept NULL and can have some values on
them, as long as the combination values is unique.
| Is This Answer Correct ? | 2 Yes | 0 No |
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 |
Answer / maneesh
Yes there can be any number of NULLs.
Remember NULL <> NULL.
So uniqueness will still be there.
Just try it out.
Maneesh
| Is This Answer Correct ? | 6 Yes | 6 No |
Answer / habibur rahaman
It depends upon the database on which you are working.....in SQL we can have only one value but in oracle we can have n no of values.......i did it practically.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sasikumar
It is possible in Oracle database (NULL <> NULL) but not
possible in SQL server.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / drona
UNIQUE constraints can accept NULL just once.
I have a dought?
Every null is different?
| Is This Answer Correct ? | 0 Yes | 0 No |
What is etl - extraction, transformation, and loading?
What is auditing in sql server?
Explain intellisense for query editing
What command do we use to rename a database?
Define Unique Key?
What is create command?
How to maintain a fill factor in existing indexes?
how we can store the value like that 001,003,023 etc in sql server 2005
What have included columns when we talk about sql server indexing?
Is trigger fired implicitely?
what purpose does OPENXML clause have in sql server stored procedure?
What is rank function?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
