Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Can we have more than one NULL in a column having unique
constraint?

Question Posted / srikanth

Answers were Sorted based on User's Feedback



Can we have more than one NULL in a column having unique constraint?..

Answer / atikullah

No, I think unique constraint contain no duplicate value in
a column. There are only contains unique value

Is This Answer Correct ?    0 Yes 1 No

Can we have more than one NULL in a column having unique constraint?..

Answer / rammohan176

yes Unique constraint accept more than one null.... because null is always not equal to another null value.i.e null<>null.
if any body have doubt please check this
CREATE TABLE TEST1 ( ENO NUMBER CONSTRAINT EU UNIQUE,
NAME1 VARCHAR2(10))

INSERT INTO TEST1 (NAME1) VALUES('RAM')

INSERT INTO TEST1 (NAME1) VALUES('KARTHIK')
INSERT INTO TEST1 (NAME1) VALUES('SANTHOSH')
INSERT INTO TEST1 (NAME1) VALUES('SANDY')

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL Server Interview Questions

How many ways to create table-valued functions?

0 Answers  

What are the types of lock supported by ?

0 Answers   HCL,

What is scheduled job and how to create it?

0 Answers  

write a query to remove duplicate records without using primary key column?

2 Answers   ABCO,

Tell me what is the order in which the sql query is executed?

0 Answers  

What do you understand by triggers?

0 Answers  

What command is used to rename the database?

0 Answers  

how to find the second salary?

10 Answers   HCL, Prithvi,

what are the advanced features in sql 2008?

2 Answers   Wipro,

Difference between aggregate functions of sql?

0 Answers   EXL,

What causes index fragmentation?

0 Answers  

What is indexing in sql server with example?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories