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
- 5538 Views
- I also Faced
- E-Mail Answers
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)
