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
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
How do use Having,Group by,Group function in SQL?
Which are ddl commands?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
How to list all login names on the ms sql server?
What is transaction server auto commit?
Define Unique Key?
what is the information that can be stored inside a bit column? : Sql server database administration
How do you know if sql server is running on your local system?
How do you improve the performance of a SQL Azure Database?
Explain transaction server isolation?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
What are page splits?
