What is difference between TRUNCATE and DELETE statement
Answer Posted / hari
Delete - is logged operation,so deletion of each row get
logged into the transcation log.
Truncate - won't logged
Delete - use where condition
Truncate - Can't use where condition
delete - fire the trigger
Trunacte - can't fire the triggger
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What stored procedure can you use to display the current processes?
What are trace flags and mention a few common trace flags used with sql server?
What are subquery and its properties?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
What are the functions in sql server?
How to create a view with data from multiple tables?
What is the difference between nvl and nvl2?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
What are the different Topologies in which Replication can be configured?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
How to send a ssrs report from ssis?
what is the difference between Tabular and Matrix report?
What Is Rdbms?
What is plan freezing?
What is table constraint?