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 difference between a function and a trigger?

0 Answers  

---

How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.

8 Answers   Intelenet,

---

What do you mean by a Composite primary key?

0 Answers   Genpact,

---

What is the basic functions for master, msdb, tempdb databases?

2 Answers   CSC,

---

Can we add a cpu to sql server?

0 Answers  

---

What about UPDATESTATISTICS ?

2 Answers   HCL, Intelligroup,

---

Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....

3 Answers  

---

What is the default port for SQL Server over a firewall?

0 Answers   Microsoft,

---

What is purpose of normalization?

0 Answers  

---

Delete duplicate records from the table?(Table must have unique id)

7 Answers   TCS, Thomson Reuters,

---

Whether the updations made to the views reflect the original records in the table

5 Answers   NIIT,

---

What is store procedure? When do you use?

0 Answers  

---