Answer Posted / 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 |
Post New Answer View All Answers
Explain nested trigger in sql?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
Which is faster statement or preparedstatement?
What does it mean to invest in the index?
How do I find the sql server database version?
What is subquery? Explain the properties of a subquery?
What is a trigger what are the advantages of trigger?
What are constraints in microsoft sql server?
How is foreign key related to primary key?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
What is the name of the Database which IBM mainframe uses?
How to download microsoft sql server 2005 express edition?
How and why use sql server?
Can we delete data from a view?
How can I create a report based on a query? : sql server management studio
