Answer / atikullah

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

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')

How global temporary tables are represented and its scope?

0 Answers  

---

what are the advanced features in sql 2008?

2 Answers   Wipro,

---

Why the trigger fires multiple times in single login?

0 Answers  

---

can we call stored Procedure in Function in Sql Server 2000 and vice versa.

3 Answers   C3I, eSoft, iPRO Solutions, Wipro,

---

What is the difference between system objects and user objects?

0 Answers   HCL,

---

Where do you find the default Index fill factor and how to change it?

0 Answers  

---

How to delete an existing row with delete statements in ms sql server?

0 Answers  

---

What is index?

1 Answers   Cap Gemini,

---

can any body tell me how to know the password of current user in sql server

0 Answers   Crea, HCL,

---

How to Execute an Operating System Command From Within SQL Server ?

3 Answers  

---

What is a periodical index?

0 Answers  

---

How do we return a record set from a Stored Procedure in SQl server 2000?

3 Answers  

---