Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / shyam
Union: It will combine the output of two or more queries &
it will eliminate duplicate values.
Union all:It will combine the output of two or more queries
& it will not eliminate duplicate values.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Does full backup break log chain?
What are the new features of sql server 2012 reporting service?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
What happens if strings are casted into wrong code pages in ms sql server?
how can a database be repaired? : Sql server administration
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
How to create an identity column?
What is the tcp/ip port on which sql server runs?
What is difference between primary key and foreign key?
what is the difference between openrowset and openquery?
Can we insert data into a view?
Explain indexed views?
What are the security related catalog views? : sql server security
How do I know if localdb is running?
