Post reply

fundamental doubt-inserted table

  • May 23, 2002 at 6:51 am

    #78761

    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??

  • May 23, 2002 at 10:31 am

    #429669

    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.

    Andy

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

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

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