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.

What are the 2 types of classifications of constraints in the sql server?

0 Answers  

---

What are different types of views?

0 Answers  

---

What is the difference between row_number and dense_rank?

0 Answers  

---

What is multi-statement table-value user-defined function?

0 Answers  

---

Can you explain full-text query in sql server?

0 Answers  

---

What are page splits?

0 Answers  

---

in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 Answers  

---

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,

---

What is the difference between DataRow.Delete() and DataRow.Remove()?

0 Answers  

---

What do you mean by cardinality?

0 Answers  

---

What is the command used to recompile the stored procedure at run time?

0 Answers  

---

What are commonly used mssql functions in php?

0 Answers  

---