I am Having tables T1 and T2 both having same data how to
check (or) compare the data in both table are same?
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 the federation in sql azure?
What are the types of processing and explain each? : sql server analysis services, ssas
What are the rules to use the rowguidcol property to define a globally unique identifier column?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
Why do we use trigger?
What action plan is preferred if sql server is not responding?
What stored procedure can you use to display the current processes?
Where the sql logs gets stored?
what is database replicaion? : Sql server database administration
What are the types of database recovery models?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
What is the report builder?
What is sqlcmd?
Describe in brief databases and sql server databases architecture.
What is b tree index?