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 two modes of authentication in sql server?
Is null in sql server?
What is the difference between the application object and session object?
How do I find the sql server instance name?
What are the purpose of Normalisation?
Can we hide the definition of a stored procedure from a use?
what is a sub-report?
Difference between drill down and drill through report.
Can a table have 2 foreign keys?
what information is maintained within the msdb database? : Sql server administration
What Is Rdbms?
Explain log shipping and mention its advantages.
Can you always create a cache of a report?
What is ms sql server service broker?
Explain the dirty pages?
