I am Having tables T1 and T2 both having same data how to
check (or) compare the data in both table are same?
Answers were Sorted based on User's Feedback
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.
Is This Answer Correct ? | 7 Yes | 1 No |
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'
Is This Answer Correct ? | 1 Yes | 0 No |
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.
Is This Answer Correct ? | 0 Yes | 1 No |
Explain powershell included in sql server 2008?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
How to how to convert numeric expression data types using the convert() function??
How do I port a number to sql server?
how to select 5 to 7 rows from a table, which contains 10 rows?
What is an index in a database?
What about UPDATESTATISTICS ?
Explain transaction server implicit?
How to turn on the mssql api module in php?
What is indexing explain it with an example?
What is merge replication?
Explain view in sql server?