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
- 5562 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 the contrast between sql and mysql?
Explain following error properties?
What are the results of running this script?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What is the architecture of ms sql reporting service?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
What is bcp? When does it used?
Explain the xml support sql server extends?
What is query parameter in ssrs?
How to read data in a table with "select" statements?
What is an inner join?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
How to get a list of columns using the "sys.columns" view in ms sql server?
Is it possible to create trigger on views?
What is schemabinding a view?
