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 |
How will u get 5 years back record?
Describe about first three Normal forms.
What are out-of-range errors with date and time literals?
Ms sql server index?
Other than truncate statement, which other command can by-pass the trigger on the tables?
how can a database be repaired? : Sql server administration
Define the term DML, DDL and DTL?
Explain about builtinadministrator?
What is query optimization process?
what are the main differences between ms access and sqlserver
WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX
4 Answers CarrizalSoft Technologies, L&T,
how can ur insert the emp table