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
- 5534 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 the purpose of linked server configuration in sql server?
You want to implement the many-to-many relationship while designing tables. How would you do it?
What is difference between stored procedure and function?
Is sql different from sql server?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
How to Get the last identity value used
How to create dbo table in sql server?
What is the usage of the sign function?
Does sql server 2000 clustering support load balancing?
DIFFERENCE BETWEEN SQL SERVER 2005 and 2008
What is indexing and its types?
What is Dedicated Administrator Connection in sql server 2005?
-
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)
