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

What is autocommit mode in sql server?

0 Answers  

---

Why I have to use stored procedures?

0 Answers   Cognizant,

---

What is the Disadvantage of indexed sequential file.

0 Answers   HCL,

---

Can we write a distributed query and get some data which is located on other server and oracle database?

0 Answers  

---

What is the difference between varchar and nvarchar types?

1 Answers  

---

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

0 Answers  

---

Does a sql server 2005 select statement require a from?

0 Answers  

---

how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.

0 Answers  

---

Is sql server implemented as a service or an application? : Sql server database administration

0 Answers  

---

In which year relase the 7.0& 2000 & 2005?

1 Answers  

---

What is the maximum rows in sql server table?

0 Answers  

---

how do we insert 100 records at a time in a table without using for loop in database

1 Answers  

---