Answer Posted / dinesh sharma
Union:Only Select Distinct Value
Union All:Select All Values Using Duplicate
All Selected Columns Must Have Same DataType
Example:
Table 1 : First,Second,Third,Fourth,Fifth
Table 2 : First,Second,Fifth,Sixth
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Tell me about builtinadministrator?
How many databases instances are there in sql server 2000?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
Does union all remove duplicates?
Explain what are partitioned views and distributed partitioned views?
How to delete database objects with "drop" statements in ms sql server?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
What command is used to rename the database?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
What is lock escalation? : sql server database administration
What is #table in sql server?
what is package and it uses and how can u call a package
How many clustered indexes there can be on table ?
What is an inner join?
Describe in brief authentication modes in sql server.
