title: Difference between Delete and Truncate in sql server. Was I wrong...?
body: <p>In a recent interview I was asked the difference between the two. I replied the general answere that all we know... </p>
  
  <p>The interviewer then asked if truncate can be rollbacked ? I replied no... </p>
  
  <p>The interviewer said that it can be rollbacked and asked me to go through the details of the behind the scene operation of both delete and truncate and check it later.</p>
  
  <p>Well i posting this question here not for just the definition and the things we know... but to get to the core of it. Throwing light on this aspect will be highly appricieated ...</p>
  
  <p>Thanks in advance</p>