Answer / praful chavan

While using TRUNCATE stmt, WHERE clause can not be used.
When we use TRUNCATE stmt, Trigger does not get fire. After
using TRUNCATE stmt, all the deleted rows are not entered in
the transaction log file(.ldf)

Answer / gk

Adding to the above answer truncate may or may not be
rolled back.
It can be rolled back if it is within a transaction.

How many types of Joins in SQL Server 2005?

9 Answers   CarrizalSoft Technologies, HCL,

---

What are the types of database schema? : sql server analysis services, ssas

0 Answers  

---

How to use "begin ... End" statement structures in ms sql server?

0 Answers  

---

What is the disadvantages of index?

3 Answers   TCS,

---

What are partitioned views and distributed partitioned views?

0 Answers  

---

---

How to make remote connection in database?

0 Answers  

---

What is stored in the mssqlsystemresource database? : sql server database administration

0 Answers  

---

What is molap and its advantage? : sql server analysis services, ssas

0 Answers  

---

What are four major operators that can be used to combine conditions on a where clause?

0 Answers  

---

how do u find least salary in a table

4 Answers  

---

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

0 Answers   ABC, TCS,

---

How to avoid cursors?

3 Answers   CarrizalSoft Technologies, HP,

---