Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2010
    Posts
    1

    Question Unanswered: triggers in sql server 2005

    I am doing my tax calculation project. In one of my module i need to automatically fire a trigger after the insertion of very march. The trigger inturn will call the procedure to calculate the tax. I need to know whether it is possible to write a trigger after the insert on every march???? Anyone could help me out... pls????

  2. #2
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    Quote Originally Posted by agneljuvani View Post
    I need to know whether it is possible to write a trigger after the insert on every march???? Anyone could help me out... pls????
    Everything you wish to know about triggers can be found here (BOL)

    CREATE TRIGGER (Transact-SQL)

    DML Triggers
    DDL Triggers
    Last edited by corncrowe; 04-05-10 at 08:23.

  3. #3
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    You may also read this article (is MSSQL 2000, but the concepts are the same):
    An Introduction to Triggers -- Part I - SQLTeam.com
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •