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
Can two different columns be merged into single column? Show practically?
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?
What are the different types of replication you can set up in sql server?
what is a join? : Sql server database administration
Define cursor locking
What is a natural primary key?
What are points to remember while using the fillfactor argument?
How optimize sql query with multiple joins in sql server?
Can we use custom code in ssrs?
Do you know exporting and importing utility?
How to get the definition of a user defined function back?
How to define and use table alias names in ms sql server?
What is nonclustered index on computed columns?
What does the not null constraint do?
What is difference between views and tables?