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 do you understand by a stored procedure?

1153

---

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

1049

---

What stored procedure would you use to view lock information?

1017

---

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1148

---

What is the difference between primary key and unique constraints?

1010

---

What is data block and how to define data block size?

1080

---

What are the properties and different types of sub-queries?

1050

---

How to list all login names on the ms sql server?

1184

---

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2854

---

What are different types of statements that are supported by sql?

1099

---

Can we deploy SSRS reports on our personal website?

176

---

How to encrypt data between dialogs?

1168

---

What action plan is preferred if sql server is not responding?

1157

---

What is inline table-value user-defined function?

1164

---

Explain features of analysis services?

1079

---