Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6296 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is cached report?
Explain what you mean by 3 tier architecture.
What do you mean by acid?
List the different types of collation sensitivities in sql server?
What is database replication?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
Explain “row_number()” in sql server with an example?
Difference between Logical Page and Physical Page in SSRS.
Why use “nolock” in sql server?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
What is openxml in sql server?
Differentiate between delete and truncate.
In what version of sql server were synonyms released?
When I delete any data from a table, does the sql server reduce the size of that table?
