Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

---

Explain different types of self contained sub query?

0 Answers  

---

Can we return Data from 4(more than 1) tables in stored procedure?

0 Answers   HCL,

---

plz send every query in sql server2000

1 Answers   Infosys,

---

Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 Answers  

---

---

How can you control the amount of free space in your index pages?

0 Answers  

---

What are the Pre Requisites when you apply Srvice Packs?

1 Answers   IBM,

---

What is temporary table in sql server? Why we use temp table?

0 Answers  

---

Is foreign key unique?

0 Answers  

---

1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

2 Answers  

---

what is the main difference between after trigger and instead trigger.

2 Answers  

---

What is data mart? : sql server analysis services, ssas

0 Answers  

---