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

explain extended properties

973


How to insert and update data into a table with "insert" and "update" statements?

958


what is database replicaion? : Sql server database administration

1164


What is the syntax for encrypting a column in SQL Server?

1103


Define union, union all, minus, intersect?

961


Do you know what is lock escalation?

994


What happens when converting big values to numeric data types?

1100


How will you hide an attribute? : sql server analysis services, ssas

936


What is normalization 1nf 2nf 3nf?

1043


can an automatic recovery be initiated by a user? : Sql server administration

935


Can we write ddl in trigger?

904


If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

962


What does it mean to normalize data?

922


What is index, cluster index and nonclustered index?

973


Tell me what is the stuff and how does it differ from the replace function?

967