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

What is the difference between a view and a stored procedure?

1037

---

How to create view in stored procedure sql server?

1015

---

How to create an identity column?

1218

---

What is the difference between DATETIME2 and DATETIME?

1074

---

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

2016

---

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

1005

---

How can you insert values in multiple rows using one Insert statement?

1091

---

What is an indice?

1031

---

Can we shrink data file in sql server?

1049

---

Is sql server a database?

991

---

What is the difference between set and select?

1092

---

What are the features of Embedded SQL

1127

---

What are the advantages of having an index on the sql server?

925

---

What is format parameter in ssrs?

146

---

what are the Prerequisites for Replication?

11349

---