Is it possible to create tables in stored procedures using a variable for the table name?

2 Answers  

---

what is package and it uses and how can u call a package

0 Answers   Satyam,

---

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers  

---

Explain forward - only cursors?

0 Answers  

---

Explain time data type in sal server 2008?

0 Answers  

---

Why I am getting this error when dropping a database in ms sql server?

0 Answers  

---

What do you understand by hotfixes and patches in sql server?

0 Answers  

---

How to find tables without indexes?

0 Answers  

---

How to use copy and concatenate commands in SQL?

0 Answers   Amdocs,

---

difference between function and procedure

3 Answers   Cognizant, HCL, TCS, Theorem,

---

can an order by clause be used in a creation of a view?

0 Answers  

---

Which are new data types introduced in sql server 2008?

0 Answers  

---