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.

Which one is faster delete/truncate? Why?

1 Answers   Infosys,

---

Indexes are updated automatically is the full-text index also updated automatically?

0 Answers  

---

Explain what are the restrictions while creating batches in sql server?

0 Answers  

---

How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?

3 Answers  

---

What do you do in data exploration

0 Answers   EXL,

---

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

0 Answers   Value Labs,

---

what is Buffer cash and Log Cache? Can you Explain it?

1 Answers   Wipro,

---

Difference between aggregate functions of sql?

0 Answers   EXL,

---

How to use subqueries with the exists operators in ms sql server?

0 Answers  

---

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

0 Answers  

---

Do you know the isolation level that sql server support?

0 Answers  

---

How to convert a table data in XML format in sql server?

0 Answers  

---