Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / saravakumar
UNION RULES
A UNION must be composed of two or more SELECT statements,
each separated by the keyword UNION.
Each query in a UNION must contain the same columns,
expressions, or aggregate functions, and they must be listed
in the same order.
Column datatypes must be compatible: They need not be the
same exact same type, but they must be of a type that SQL
Server can implicitly convert.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What are logical database components? : SQL Server Architecture
Explain some stored procedure creating best practices or guidelines?
Can we shrink data file in sql server?
What is Service Broker in sql server 2012?
Other than truncate statement, which other command can by-pass the trigger on the tables?
What are sql servers used for?
Explain what is it unwise to create wide clustered index keys?
How to rebuild master databse?
What are the operating modes in which database mirroring runs?
How you can move data or databases between servers and databases in sql server?
What is a join in sql? What are the types of joins?
Explain user defined functions?
Can you explain different types of locks in sql server?
Explain the difference between functions and stored procedures in sql server?
What is the default fill factor value?
