what is the difference between delete table and truncate table commands? : Sql server database administration

0 Answers  

---

Why do we use stored procedures in sql server?

0 Answers  

---

What are the differences between UNION and JOINS?

3 Answers   CarrizalSoft Technologies,

---

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

0 Answers  

---

How to update muliple row in single query?

0 Answers   MCN Solutions,

---

---

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  

---

What is save transaction and save point?

0 Answers  

---

How to query multiple tables jointly?

0 Answers  

---

What is collation sensitivity? Explain different types.

0 Answers  

---

Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

6 Answers  

---

Tell me what is the order in which the sql query is executed?

0 Answers  

---

What is the difference between varchar and nvarchar datatypes?

0 Answers  

---