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

What is outer join in sql server joins?

0 Answers  

Explain relational data?

0 Answers  

What is a non-clustered index?

0 Answers  

How to disable triggers using "disable trigger"?

0 Answers  

what are the Prerequisites for Replication?

1 Answers   IBM,

How to rebuild master databse?

0 Answers  

How to set database to be read_only in ms sql server?

0 Answers  

How to get the definition of a stored procedure back?

0 Answers  

What is a periodical index?

0 Answers  

What is 'Join' and explain its various types.

0 Answers   Genpact,

How to receive output values from stored procedures?

0 Answers  

What are the factors you will check for the performane optimization for a database query?

7 Answers   CarrizalSoft Technologies, DELL, SoftSol,

For more SQL Server Interview Questions Click Here
Categories