Answer Posted / ramesh raja
UNION: combine distinct values between two tables
UNION ALL : combine all values and also duplicates values
between the two tables
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
what are the different types of replication you can set up in sql server? : Sql server database administration
How to check if a table is being used in sql server?
How can sql server instances be hidden? : sql server security
Can binary strings be converted into numeric or float data types?
How do I open a .db file?
What are different types of constraints?
Do you know what guidelines should be followed to help minimize deadlocks?
What is the difference between a fill factor of 100 and 0?
What are xml indexes?
What are the steps you can take to avoid “deadlocks”?
How do I schedule a sql server profiler trace?
Why use “pivot” in sql server?
How to add additional conditions in SQL?
What is the difference between count and distinct count?
Explain trigger and trigger types?