You must Sign In to post a response.
  • Category: ASP.NET

    Trigger....

    hi frind...i need ur help..


    1- i have created trigger so where it will save.so plz tell me..query i want retive my trigger ..

    thanks
    papu
  • #575909
    hi kumar

    The trigger that u have created will be stored beneath the table name..

    database-->tables-->when u expand tables column in database, u will find sub folders like columns, keys, contraints, triggers, etc..
    ur trigger will be stored in trigger subfolder..

  • #575915
    A trigger is a block of code that constitutes a set of T-SQL statements that are activated in response to certain actions or conditions.

    A trigger can also be interpreted as a special kind of stored procedure that is executed whenever an action,such as data modification,takes place.

    A Trigger is fired whenever data in the underlying table is affected by any of the Data Manipulation Language (DML) statements -INSERT,UPDATE,OR DELETE.

    Triggers help in maintaining consistent,reliable,and correct data in tables.They enable the performance of complex actions and cascade these actions to other dependent tables.


    Thanks & Regards


    Bunty

  • #575931
    Open Database>>Programmability>>DatabaseTriggers
    Then expand DatabaseTriggers there you find your Triggers created .

    Regards
    Pankaj Rajput

  • #576901
    hi....satish..
    thanks for post me ur ans..i found


  • This thread is locked for new responses. Please post your comments and questions as a separate thread.
    If required, refer to the URL of this page in your new post.