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 use of attribute hierarchy ordered ? : sql server analysis services, ssas

0 Answers  

What is the process of indexing?

0 Answers  

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

0 Answers  

How do I find query history in sql server?

0 Answers  

Explain what is sql server english query?

0 Answers  

What do you mean by stored techniques? How would we use it?

0 Answers  

How to list all columns in a table using odbc_columns()?

0 Answers  

Is the order of columns in the set clause important in ms sql server?

0 Answers  

What is cursor in ms sql server?

0 Answers  

What are the essential components of sql server service broker?

0 Answers  

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

7 Answers   Value Labs,

how many type of subquery?

2 Answers  

For more SQL Server Interview Questions Click Here
Categories