Difference between server.transfer and server.execute method?

2 Answers  

---

Explain about nested stored procedure?

0 Answers  

---

What is clustered vs nonclustered index?

0 Answers  

---

What is the purpose of the tempdb database?

0 Answers  

---

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

2 Answers   HCL,

---

Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?

5 Answers   eFunds,

---

What is difference between TRUNCATE and DELETE statement

12 Answers   CTS,

---

Tell me what are the essential components of sql server service broker?

0 Answers  

---

how to delete duplicate rows in sql server2005

7 Answers   Cisco, CTS, HCL, IBM,

---

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 Answers  

---

Where is my database stored on the hard disk in ms sql server?

0 Answers  

---

What do you mean by table and field in sql?

0 Answers  

---