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

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers  

---

Tell me can we use custom code in ssrs?

0 Answers  

---

Define outer join?

0 Answers  

---

What are sparse columns?

0 Answers  

---

What is index, cluster index and nonclustered index?

0 Answers  

---

How to use copy and concatenate commands in SQL?

0 Answers   Amdocs,

---

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

0 Answers  

---

How to create hyperlink from returned sql query ?

0 Answers   MCN Solutions,

---

What is transactional replication?

0 Answers  

---

How to count groups returned with the group by clause in ms sql server?

0 Answers  

---

Can group by and orderby be used together?

0 Answers  

---

Write a SQL query to make a column as unique?

0 Answers   Cap Gemini,

---