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...

i want to join two queries....and i want to run them as one
after another that is want output of first query then
second , then again output of first query then second and
so on...

Answer Posted / vrinda

DECLARE @i int
SET @i=0
While @i<10
Begin
if @i%2=0
BEGIN
SELECT * FROM Table1
END
ELSE
BEGIN
SELECT * FROM Table2
END
END

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do clustered indexes store data?

1093


explain different types of cursors? : Sql server database administration

1078


Why should we go for stored procedures? Why not direct queries?

1087


What is Extended user-defined?

950


What Are the Main Features of SQL Azure?

117


explain different types of backups avaialabe in sql server? : Sql server database administration

962


What is the purpose of forms?

948


What is catalog views?

1062


What is the ‘fillfactor’?

964


List the advantages of using stored procedures?

1043


What is use of except clause? How does it differ from not in clause?

1013


What is difference between count (*) and count 1?

919


How can you manage sql azure security?

101


Explain powershell included in sql server 2008?

1043


What is etl - extraction, transformation, and loading?

913