Answer Posted / shabanafazal
in case of 'union' the data of two tables are combined
together with no repetition where as incase of 'union all'
repetition of data is done e.g in table 'A' we have name
saad three times and in 'B' table name 'ssad' is present
one time then in case of 'union' 'saad' is appeard once
(when union of table 'A' and 'B' is done). where as in case
of 'union all' the name 'saad' will repeated four times.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain few examples of stored procedure over triggers?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
Explain indexes disadvantages?
what stored procedure can you use to display the current processes? : Sql server administration
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
How to rebuild all indexes on a single table?
How to get the definition of a stored procedure back?
Explain a differential backup?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
What is field with example?
Explain indexing and what are the advantages of it?
What are sub reports and how to create them?
How do use Having,Group by,Group function in SQL?
on line cluster can we make if yes tell me the procedure
What is parameterized reports in ssrs ?
