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.

What is the stuff and how does it differ from the replace function?

0 Answers  

---

How to create view in stored procedure sql server?

0 Answers  

---

Do you know what is sql service broker?

0 Answers  

---

Why use identity in sql server?

0 Answers  

---

What is a db view?

0 Answers  

---

---

How to create new table with "create table" statements?

0 Answers  

---

What is the purpose of the tempdb database?

0 Answers  

---

Is t sql the same as sql server?

0 Answers  

---

why cluster and non clusterindex are used in sqlserver 2000? explain with example

1 Answers  

---

Explain various data region available in ssrs with their use?

0 Answers  

---

Please tell me some knowledge about Clustering and how to add clustering?

1 Answers  

---

List some of the rules that apply to creating and using a ‘view’

0 Answers  

---