State the difference between local and global temporary tables?

0 Answers  

---

Define a cross join?

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  

---

Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

3 Answers   247Customer,

---

What is INTVAL( )and where we use Plz any body help me

1 Answers  

---

---

How do you debug a procedure in sql server?

0 Answers  

---

What is extent? Types of extents?

0 Answers  

---

What is the significance of null value and why should we avoid permitting null values?

0 Answers  

---

ehat is the default port no of sql 2000?

2 Answers   IBM,

---

what operator performs pattern matching?

2 Answers  

---

How do I save a stored procedure in sql server?

0 Answers  

---

Working with TLogs

0 Answers  

---