Answer / asharaf ali

(SELECT * FROM @T1
EXCEPT
SELECT * FROM @T2)
UNION
(SELECT * FROM @T2
EXCEPT
SELECT * FROM @T1)

If the above query returned no records, the data in both table are same.

Answer / saravanan p

Declare @chkSameTable int
Select @chkSameTable=count(*) from
((SELECT * FROM ##SameTable
EXCEPT
SELECT * FROM ##SameTable1)
UNION
(SELECT * FROM ##SameTable1
EXCEPT
SELECT * FROM ##SameTable)) DrvTable

If @chkSameTable=0
Print N'The Two Tables are having Same data'
Else
Print N'The Two Tables are having Diferent data'

Answer / thakur singh rawat

(select * from T1
minus
select * from T2)
union
(select * from T2
minus
select * from T1)

If no rows returns then it means that the two tables
contain the same values or say same.

how to copy only distinct data into another table which is not already exist in database?

2 Answers   Spectra,

---

Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

3 Answers   247Customer,

---

Where the sql logs gets stored? : sql server database administration

0 Answers  

---

Write the queries for commands like Create Table, Delete table, Drop Table etc.

0 Answers   HPCL, Hughes Systique Corporation,

---

Can you explain what are commit and rollback in sql?

0 Answers  

---

What is a dbms wizard?

0 Answers  

---

What are the recovery models in sql server 2000?

0 Answers  

---

Explain the different index configurations a table can have?

0 Answers  

---

What is Right Outer Join?

2 Answers  

---

tell me the disaster recovery plan

0 Answers   Microsoft,

---

how to define testing of network layers? : Sql server database administration

0 Answers  

---

What is a view?

6 Answers  

---