Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between UNION and UNIONALL?
- 5 Answers
- 14157 Views
- CarrizalSoft Technologies, CTS, I also Faced
- E-Mail Answers
Answer Posted / subramanya gv
Union is used to combining the data with out duplication and
effectively it is faster.
Union all is used to combining the data with duplication so
comparatively it is slower.
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
How to provide values to user defined function parameters?
how many clustered indexes can be created on a table? : Sql server database administration
What is the benefit of normalization?
What is a natural primary key?
Explain the difference between delete,drop and truncate in SQL Server?
What is the purpose of a table?
What is subquery? Explain the properties of a subquery?
What is the difference between ddl,dml and dcl commands?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What is the difference between functions and scalar functions?
what is the system function to get the current user's user id? : Sql server database administration
What is raiseerror? What is raiseerror?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
Explain database normalization?
Explain about Normalization?
