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

What is right outer join in sql server joins?

0 Answers  


what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  


How to change the system date and time from SQL Plus Terminal ?

0 Answers   MCN Solutions,


If we shrink the Databse and Files, how much size is decreased?

1 Answers   TCS,


What types of integrity are enforced by a foreign-key constraint

1 Answers  






Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 Answers   Techno Solutions,


What Is The Difference Between Primary Key & Super Key

3 Answers   Accenture,


What is named query? : sql server analysis services, ssas

0 Answers  


How do I get to sql server configuration manager?

0 Answers  


What is the difference between an index and a unique index?

0 Answers  


Explain triggers in sql?

0 Answers  


what is trigger

1 Answers   CarrizalSoft Technologies, NIIT,


Categories