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...
- 2 Answers
- 5435 Views
- I also Faced
- E-Mail Answers
Answer Posted / ashna thampi
declare @i int
set @i=1
while @i < 100
begin
if (@i)%2 =1
begin
select * from TABLE1
end
else
select * from TABLE2
set @i=@i + 1
end
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Is sql server is free?
What are cursors stored procedures and triggers?
What are rest-style architecture's?
Is ssrs support other database except ms sql server?
What is the difference between having clause and where clause in sql server?
How to access the inserted record of an event?
Explain cdc and sql injection?
Can we use where and having clause together?
How to filter out duplications in the returning rows in ms sql server?
Which tcp/ip port does the sql server run on? How can it be changed?
Tell me what is sql profiler?
Explain partitioned view?
Why use view instead of a table?
Explain about merge replications?
How would you choose between a clustered and a non-clustered index?
