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.

Difference between Function and Procedure-in general?

6 Answers  

---

What does the update command do?

0 Answers  

---

What program is used to store the data source file?

0 Answers  

---

What do you understand by replication in sql server?

0 Answers  

---

Do you know data definition language, data control language and data manipulation language?

0 Answers  

---

---

What is extended stored procedures?

0 Answers  

---

Explain Geography datatype in SQL Server

0 Answers   Infosys,

---

Difference between DELETE and TRUNCATE?

0 Answers   TCS,

---

What are commit and rollback in sql?

0 Answers  

---

What are the advantages of using sql server over ms access or why should one use sql instead of ms access

2 Answers   CMS, Impetus,

---

How would you choose between a clustered and a non-clustered index?

0 Answers  

---

What is the difference between coalesce() & isnull()?

0 Answers  

---