Post reply

what is use of Trigger in an Application?

  • January 4, 2008 at 12:26 am

    #177892

    Please, Give me details what is use of Trigger in an Application?

  • January 4, 2008 at 12:40 am

    #764691

    What do you mean by trigger on an application? Triggers are placed on tables and views.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 4, 2008 at 2:13 am

    #764715

    i know its fire when we insert,update,delete in table. But what its use in asp.net application. Because Trigger fire on SQL server.

    & why we use trigger for insert/update/delete?

  • January 4, 2008 at 2:30 am

    #764721

    Triggers are used when you want something to happen when rows are inserted, updated or deleted, regardless of where the data change came from (app, management studio, job,...)

    Auditing data changes is a major use for them

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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