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
- 5537 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 table value parameters (tvp)?
What is a linked server in sql server?
What are trace flags?
Define left outer join in sql server joins?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
What is self contained scalar sub query?
What is transact-sql language?
What is triggers and its types?
Mention the 3 ways to get a count of the number of records in a table.
How to find out the list schema name and table name for the database?
Tell me about builtinadministrator?
Explain the advantages of merge replication?
What stored by the msdb?
What is field in algebra?
System variable and temporary variables
