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
- 5580 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 |
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
How to count the number of duplicate items in a table?
Explain the difference between clustered and non-clustered index?
How do I find the port number for sql server?
What are scalar functions?
What are the types of table?
Can we insert data into a view?
What is plan freezing?
What is wide table?
How to create a new login name in ms sql server?
Explain what is the purpose of sql profiler in sql server?
When is the use of update_statistics command?
-
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)
