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 to drop existing indexes in ms sql server?

1013


You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

892


Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2666


What is the server name for sql management studio?

947


If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

971


Why do we use trigger?

915


What action plan is preferred if sql server is not responding?

1034


What are advantages of ssrs or why we should use ssrs?

129


What is the impact on other user sessions when creating indexes?

872


What is wide table?

885


What are system databases in ms sql server?

965


What is page-level compression?

902


Find nth lowest salary or get nth lowest salary?

965


Explain how to use linked server?

925


What is SQL Azure Fabric?

108