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 purpose of UPDATE STATISTICS?

2 Answers  

---

What is a filestream?

0 Answers  

---

What is difference between temp table and cte?

0 Answers  

---

What are the Advantages of using CTE in sql server?

0 Answers   Winsol Solutions,

---

i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj

9 Answers   IBM,

---

---

Hi SQL gurus, i am working for an MNC... My team is having a problem in sql server. when user slects date prompts from jan 1st to april 30, it should display all months data like : jan aa feb bb mar cc but when it comes to april its taking data like : jan aa feb bb mar cc apr dd...and so on means its taking data again from jan to april which we dont want. we want the data only april month as we are getting jan, feb and mar... can any one write the code to relsove the issue please would be greatful if you can send to shiva_sans@yahoo.co.in and also please send your email also ...so that we will be in touch for any kind of queries ... Thanks a lot in Advance !!!

1 Answers  

---

Can you insert NULL in unique column?

0 Answers   MCN Solutions,

---

Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?

1 Answers  

---

When to use Inner join & when to use subquery?

0 Answers   IBM,

---

what is the signification difference of this bit data type between sql 6.5 and later version sql server?

1 Answers  

---

How to disable triggers using "disable trigger"?

0 Answers  

---

How to provide values to stored procedure parameters in ms sql server?

0 Answers  

---