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
- 6242 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
explain databases and sql server databases architecture? : Sql server database administration
How many types of objects are there?
Why do you need a sql server?
what is unique and xaml nonclustered index
What do you understand by integration services in sql server?
Explain how to maintain a fill factor in existing indexes?
Why truncate is ddl command?
What protocol does sql server use?
How do I find sql server instance name?
Why we use the openxml clause?
What are the Advantages of using CTE in sql server?
How to create a new schema in a database?
How to change parameter value inside the report?
What is the difference between update lock and exclusive lock?
Which table keeps the locking information?
