What Are Three Rules to Use UNION IN SQL SERVER



What Are Three Rules to Use UNION IN SQL SERVER..

Answer / 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

More SQL Server Interview Questions

After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?

0 Answers   Cognizant,


What is a database in ms sql server?

0 Answers  


How many columns can we include on clustered index ?

0 Answers  


How many levels of sp nesting are possible?

0 Answers  


What is transactional replication?

0 Answers  






What is a livelock?

0 Answers  


What is difference between standardization and normalization?

0 Answers  


How network traffic be reduced by using the stored procedure?

0 Answers   Accenture,


Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

0 Answers  


explain different types of jions with examples briefly?

2 Answers   Accenture, Excellence, Zensar,


How to find the source of a table in sql server?

0 Answers  


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

0 Answers  


Categories