What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
Answer Posted / srisenthil
delete table gives the transactional log where as in
truncate it is not delete the total rows inthe table but
structure of the table has never changed after the
statement is executed it is roll back and the constraints
after the delete statement is remain same where as it is
not in the truncate statement
Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What is dbcc command in sql server?
Explain the use of containers in ssis?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What are click through reports?
What is left outer join in sql server joins?
How to create median function?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
Why we should not use triggers?
Explain mixed authentication mode of sql server?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
Do you know what is normalization of database? What are its benefits?
What are the new scripting capabilities of ssms? : sql server management studio
What xml support does the sql server extend?
What is difference between views and stored procedures?
How to drop an existing user defined function in ms sql server?