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
- 5678 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what is memory-optimized nonclustered indexes
How to select some specific rows from a table in ms sql server?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
Do you know what is similarity and difference between truncate and delete in sql?
How to transfer data from a cursor to variables with a "fetch" statement?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What are the hotfixes and patches in sql server?
Explain different types of self contained sub query?
Explain about system stored procedure?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
Explain atomicity?
What do I need to start working with sql studio? : sql server management studio
Explain important index characteristics?
Is it safe to delete log files?
