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...
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
What is xdr?
What is row-level compre?
What is data compression?
What is executereader?
What is an execution plan?
When do we use the UPDATE_STATISTICS command?
4 Answers Deutsche Telekom AG,
What do you understand by the analysis services in sql server?
What is a user-defined function in the sql server and what is its advantage?
How to change the ownership of a schema in ms sql server?
What stored by the model?
What stored by the msdb? : sql server database administration
What is standby servers? Explain types of standby servers.
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)