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
- 5581 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
What is change data capture (cdc) feature?
How to change the data type of an existing column with "alter table" statements in ms sql server?
Explain filestream storage of sql server 2008?
Explain the use of keyword with encryption. Create a store procedure with encryption?
role of sql sever 2005 in database rather than any other database
How to update multiple rows with one update statement in ms sql server?
What area unit the various kinds of info compression introduced in sql server 2008?
Can sub report data source be different from that of the parent report?
What is the difference between left and right outer join?
What is de-normalization and what are some of the examples of it?
explain different types of joins? : Sql server database administration
To which devices can a backup be created and where should these devices be located? : sql server management studio
How to view the error log for any specific instance? : sql server database administration
Define outer join?
Can I use sql azure as a backup with log shipping or database mirroring?
