I am Having tables T1 and T2 both having same data how to
check (or) compare the data in both table are same?
- 3 Answers
- 6451 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is a coalesce function?
What is an indexed view?
What is standby servers? Explain types of standby servers.
what is the Ticketing tool used in Wipro technologies at Bangalore...???
do you know how to configure db2 side of the application? : Sql server database administration
Explain “row_number()” in sql server with an example?
How can we solve concurrency problems?
How do I find the sql server version?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
what is the difference between openrowset and openquery?
What is a view in sql?
How efficient you are in oracle and SQL server?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
How to convert numeric expression data types using the cast() function?
What is acid mean in sql server?
