what are the advanced features in sql 2008?

2 Answers   Wipro,

---

Explain the microsoft sql server delete command? : SQL Server Architecture

0 Answers  

---

What is the basic functions for master, msdb, tempdb databases?

2 Answers   CSC,

---

how can u select the Distinct values in the table, table having 20 columns , i want all columns

2 Answers  

---

how to do partition in sqlserver

0 Answers   TCS,

---

How do we get current date in SQL Server 2000, Oracle, MS Access?

13 Answers  

---

What are extended events in sql server?

0 Answers  

---

Write a sql query to delete duplicate records from a table called table1

0 Answers  

---

role of sql sever 2005 in database rather than any other database

0 Answers  

---

on line cluster can we make if yes tell me the procedure

0 Answers   Microsoft,

---

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

---

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  

---