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
- 5590 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 |
How to create indexed view?
How to delete the duplicate rows from a table in SQL Server ??
What are SQL Jobs, please mention the use of it and how to create them.
Explain about nested stored procedure?
What is dml command?
explain declarative management framework (dmf) in sql server 2008?
ow to bring suspect mode datbase online from scratch
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
what are user defined datatypes and when you should go for them? : Sql server database administration
How to optimize stored procedure optimization?
Are resultset updatable?
Explain some DBCC commands?
-
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)
