Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What Are Three Rules to UseĀ UNION IN SQL SERVER

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


Please Help Members By Posting Answers For Below Questions

How to set database to be single_user in ms sql server?

1018


Is it safe to delete log files?

908


Explain different types of lock modes in sql server 2000?

926


What are the types of lock supported by ?

1037


How do I find the query plan in sql server?

946


How to replace given values with null using nullif()?

980


Can you type more than one query in the query editor screen at the same time?

1003


How to create a trigger for insert only?

1030


What are examples of triggers?

1078


How to select true false based on column value in sql server?

1010


What are the 2 types of classifications of constraints in the sql server?

1112


Define synonym?

1159


What are commonly used mssql functions in php?

1068


What are the differences between clustered and non-clustered index?

1016


Mention what are the different types of ssrs reports?

150