• for triggers, refer bol at

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/edeced03-decd-44c3-8c74-2c02f801d3e7.htm

    contains complete syntax with examples.

    for Procs, refer bol at

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/afe3d86d-c9ab-44e4-b74d-4e3dbd9cc58c.htm

    this page also has good basic examples.

    You can start writing your solution based on the understanding from these and let us know if u're stuck somewhere 🙂



    Pradeep Singh