What is SQL Server?

0 Answers   Atos Origin,

---

Differentiate between a local and a global temporary table?

0 Answers  

---

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  

---

What is the difference between stored procedure and functions?

0 Answers   MCN Solutions,

---

What is merge statement?

0 Answers  

---

---

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

0 Answers  

---

What is sql server profiler trace data file?

0 Answers  

---

What is the default isolation level of the sql server database?

1 Answers   Ness Technologies,

---

How to create prepared statements using odbc_prepare()?

0 Answers  

---

Differentiate between delete and truncate.

0 Answers  

---

Explain primary key?

0 Answers  

---

How to make a remote connection in a database?

0 Answers  

---