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 what is sql service broker?

0 Answers  

---

What is the difference between a fill factor of 100 and 0?

0 Answers  

---

What is difference between stored procedure & function?

3 Answers   CarrizalSoft Technologies, Concept Infoway, TATA,

---

Difference between drill down and drill through report.

0 Answers  

---

Explain what are magic tables in sql server?

0 Answers  

---

---

what is a traditional network library for sql servers? : Sql server database administration

0 Answers  

---

Is it possible to replicate data from sql server to oracle? : sql server replication

0 Answers  

---

Define inner join in sql server joins?

0 Answers  

---

What is the difference between for auto and for nested?

0 Answers  

---

How to insert new line characters into strings?

0 Answers  

---

How to call stored procedure using http soap?

0 Answers  

---

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

0 Answers  

---