Post reply

DELETE Trigger

  • April 16, 2004 at 9:37 am

    #111049

    Hello,

    I'm in the process of writing an INSTEAD OF DELETE trigger and what I'm trying to accomplish is this, When record(s) is deleted in the triggered table, I would like the record(s) from the deleted triggered table to be stored in another table that I created, not all of the records when a DELETE is triggered.  Otherwards, I need some sort of validation.

    How can I accomplish this?

    Thank you for your help.

    Peter

     

     

    Peter M. Florenzano

    Database Administrator

  • April 17, 2004 at 5:46 am

    #503246

    Well you can insert the deleted data from the deleted table to the desired table, well I didnot exactly get your question though, However you may want to refer to

    Using the inserted and deleted Tables in BOL

     

    Prasad Bhogadi
    www.inforaise.com

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

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