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

Do you know the policy based administration feature of sql server 2008?

0 Answers  

---

Explain about nested stored procedure?

0 Answers  

---

How do I find sql server instance name?

0 Answers  

---

What are the joins in sql server? : sql server database administration

0 Answers  

---

How do you measure the performance of a stored procedure?

3 Answers   Infosys,

---

How do you debug a procedure in sql server?

0 Answers  

---

role of sql sever 2005 in database rather than any other database

0 Answers  

---

What is subquery explain with example?

0 Answers  

---

you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

0 Answers  

---

What is difference between unique and primary key?

0 Answers  

---

What happens on checkpoint?

0 Answers  

---

default databases available in sql server and there uses ?

4 Answers   TCS,

---