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
How is SQL Azure different than SQL server?
Explain can SSRS reports Cache results?
How to create an index on an existing table in ms sql server?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
Does index slows down insert statements?
How do you troubleshoot errors in a SQL Server Agent Job?
What is the purpose of forms?
How do I save a stored procedure in sql server?
What do you mean by authentication modes in sql server?
What are the different methods available under sqlcommand class to access the data?
How to divide query output into multiple groups with the group by clause in ms sql server?
what is a self join? : Sql server database administration
What happens if you add a new index to large table?
What are the new features of sql server 2008 r2 reporting service?
Is a primary key unique?
