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.

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

0 Answers  

---

find 2nd highest salary of person using cursor concept?

6 Answers   HCL,

---

How do you find the error, how can you know the number of rows effected by last SQL statement?

2 Answers  

---

What is the architecture of ms sql reporting service?

0 Answers  

---

where do you use Isolations?give me some exmpale?

1 Answers  

---

---

What is a covered index?

0 Answers  

---

Can we insert data into a view?

0 Answers  

---

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

0 Answers  

---

How do you debug a procedure in sql server?

0 Answers  

---

How to concatenate two character strings together?

0 Answers  

---

What is the process of normalising?

0 Answers  

---

Is SET a SQL Keyword?

4 Answers   BitWise,

---