wt is the meaning of log file and rolbck n truncte n dlt cmd

Question

hi frnds wants to know that with example wt is the meaning of log file and rollback n truncate n deletet cmd? means delete cmd is roll back bt truncate is not? truncate is log file but delete is not?

Vivek Kumar · Answer

Hi Anjali Please go through the below links for your reference. http://codebetter.com/raymondlewallen/2005/05/09/the-difference-in-truncate-and-delete-in-sql-server/ http://www.orafaq.com/faq/difference_between_truncate_delete_and_drop_commands http://www.sqlservercurry.com/2011/01/rollback-transaction-in-sql-server.html https://msdn.microsoft.com/en-in/library/ms190925.aspx --------------------------------------------------- If this post helps you mark it as answer