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
Is the log file is a part of file group?
What will be the maximum number of index per table?
How to connect to a sql server using odbc_connect()?
What is the meaning of resultset type_scroll_insensitive?
What is transaction server isolation?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
Is sql server free?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
What does set rowcount do?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is collation?
What are the different types of sql server replication? : sql server replication
How do database indexes work?
Explain the difference between functions and stored procedures in sql server?
What is rolap and its advantage? : sql server analysis services, ssas
