fundamental doubt-inserted table

  • I am new to SQL Server and have a doubt about inserted and deleted tables

    I am confused as to whether records are stored into inserted and deleted tables

    whenever an insert statement or delete statement is executed or only when an insert or delete trigger is assosciated with an insert or delete statement.

    Could anyone please enlighten me??

  • Inserted is populated for an insert or an update, deleted is populated for a delete or an update. For updates you're getting the before (deleted) and after (inserted) images of the data, minus text columns.


Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply