Explain the properties of subqueries in sql server?

0 Answers  

---

How to create nested stored procedure?

0 Answers  

---

How to swap the data of two columns in a table. both the columns containing varchar values.

9 Answers  

---

Write a SQL query to delete a table?

0 Answers   Amdocs,

---

What is the maximum size of a dimension? : sql server analysis services, ssas

0 Answers  

---

---

Is candidate a key?

0 Answers  

---

difference between sql server2000 and sql server2005

1 Answers   KPMG,

---

Write the SQL query to drop, truncate and delete table.

0 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

What is the difference between DataRow.Delete() and DataRow.Remove()?

0 Answers  

---

How to genrate automaticlly empid like gt001

4 Answers  

---

How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?

2 Answers   Genpact,

---

How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)

10 Answers   Cognizant, Infosys,

---