Answer Posted / samy
Union:
combine two tables and common values to be retrieved no
duplicate values
Union All:
All the values to be retrieved when combine two table.
(duplicate values)
Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What is meant by indexing files?
What is the index requirement in SQL Azure?
How many full-text indexes can a table have?
What is use of except clause?
What command do we use to rename a db, a table and a column?
What is the security model used in sql server 2005?
What is user defined datatypes and when you should go for them?
How many joins in sql server?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
Explain syntax for disabling triggers?
How to identify current user in ssrs report?
What is a data source file?
How to bind a view to the schema of the underlying tables?
In what version of sql server were synonyms released?
What are the restrictions while creating batches in sql server?