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 function of inner join?

0 Answers  

---

Do you know what are different types of replication in sql server?

0 Answers  

---

how can i store resumes in database?

3 Answers   HCL,

---

What is cdc in sql server?

0 Answers  

---

What are the steps to process a single select statement?

0 Answers  

---

Can we linked SharePoint to a SQL database?

0 Answers   Sans Pareil IT Services,

---

What does it mean to have quoted_identifier on? What are the implications of having it off?

2 Answers  

---

how to know Who Is Blocking Your SQL Server?

4 Answers  

---

What is update_statistics command?

0 Answers  

---

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

2 Answers  

---

Does server sql treat char as a variable-length or fixed-length column?

0 Answers  

---

How to assign new column names in a view?

0 Answers  

---