wat new abt truncate in sql server
Answers were Sorted based on User's Feedback
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)
Is This Answer Correct ? | 12 Yes | 0 No |
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.
Is This Answer Correct ? | 4 Yes | 0 No |
Why do we use sql limitations? Which constraints can we use while making a database in sql?
List some major differences between triggers and stored procedures?
how to connect sybase to sql server 2005?.
Can select statements be used on views in ms sql server?
Explain what is scheduled job and how to create it?
What is ms sql server reporting services?
Explain database normalization?
What is the stuff and how does it differ from the replace function?
How do SQL server 2000 and XML linked?
How to enter binary string literals in ms sql server?
How to write query to Delete the records in child table and corresponding records in parent table
What does it mean to invest in the index?