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 can u get the number of pupils connecting the database?

1 Answers   Cap Gemini,

---

How many types of indexes are there in SQL Server?

6 Answers   CarrizalSoft Technologies, United Healthcare,

---

hi ..i am working as a sql dba.....now i want to learn more about t-sql..... is it possible to learn online.... plz refer any site ..thankq

0 Answers   IBM,

---

What happens when unicode strings concatenate with non-unicode strings?

0 Answers  

---

What is difference between foreign key and unique key?

0 Answers  

---

Diffrences between sql server 2000 vs 2008

0 Answers   TCS,

---

List out the differences between global and local temp tables in sql server?

0 Answers  

---

What is the purpose of optimization?

0 Answers  

---

How can a database be repaired?

0 Answers  

---

What is the datatype returned by count(*)

22 Answers   247Customer, Asian CERC,

---

Explain the working of sql privileges?

0 Answers  

---

How do you know if sql server is running on your local system?

0 Answers  

---