Answer Posted / 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 to optimize stored procedures in sql server?

1176

---

What is temporal table?

879

---

What is the difference between row_number and dense_rank?

872

---

How to loop through returning rows?

1028

---

What is hot add cpu in sql server 2008?

920

---

What is the purpose of object explorer and its features? : sql server management studio

1199

---

What is collation sensitivity? Explain different types.

1005

---

What do you understand by check constraint in sql server?

939

---

Which joins are sql server default?

998

---

How to divide query output into multiple groups with the group by clause in ms sql server?

1026

---

How do I open a .db file?

1033

---

What is executereader?

944

---

How do I trace a query in sql server?

948

---

Why does sql studio use a single registered database repository? : sql server management studio

989

---

How to select some specific rows from a table in ms sql server?

999

---