What is difference between TRUNCATE and DELETE statement

12 Answers   CTS,

---

What are the advantages of user defined function?

0 Answers  

---

How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.

1 Answers  

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

State the difference between union and union all?

0 Answers  

---

---

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

0 Answers  

---

wat is tuff file in log shipping, wt is d use of tht file?

1 Answers   TCS,

---

What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....

9 Answers   DELL, i Tech, Infosys, Siemens, TCS,

---

How do you load large data to the SQL server database?

2 Answers  

---

SQL Server Performance Tuning for Stored Procedures & reducing debugging time?

1 Answers   CarrizalSoft Technologies,

---

what are defaults? : Sql server database administration

0 Answers  

---

Explain the properties of a relational table?

0 Answers  

---