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

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

What is the most common type of join?

0 Answers  

---

difference between Clustered index and non clustered index ?

0 Answers   Infosys,

---

How to create an multi-statement table-valued function?

0 Answers  

---

How you would rewrite the sql query to return the customerid sorted numerically?

0 Answers  

---

What are triggers? How do you invoke a trigger on demand?

0 Answers   Hexaware,

---

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

0 Answers  

---

what is the diffrence between Snap Shot and Transaction Replication

2 Answers   CSC,

---

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

0 Answers  

---

What is not null constraint?

0 Answers  

---

What is built-in function?

0 Answers  

---

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  

---

How to use values from other tables in update statements in ms sql server?

0 Answers  

---