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 |
What is right outer join in sql server joins?
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
How to change the system date and time from SQL Plus Terminal ?
If we shrink the Databse and Files, how much size is decreased?
What types of integrity are enforced by a foreign-key constraint
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.
What Is The Difference Between Primary Key & Super Key
What is named query? : sql server analysis services, ssas
How do I get to sql server configuration manager?
What is the difference between an index and a unique index?
Explain triggers in sql?
what is trigger
1 Answers CarrizalSoft Technologies, NIIT,