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

Can two different columns be merged into single column? Show practically?

1066


How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1111


What are the different types of replication you can set up in sql server?

1052


what is a join? : Sql server database administration

1250


Define cursor locking

1007


What is a natural primary key?

1046


What are points to remember while using the fillfactor argument?

970


How optimize sql query with multiple joins in sql server?

901


Can we use custom code in ssrs?

1115


Do you know exporting and importing utility?

1040


How to get the definition of a user defined function back?

1044


How to define and use table alias names in ms sql server?

1133


What is nonclustered index on computed columns?

960


What does the not null constraint do?

1088


What is difference between views and tables?

1010