Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2003
    Location
    East Grinstead ,UK
    Posts
    19

    Unanswered: Insert and Update Triggers

    Hi there,
    I want to create a trigger where by inserts and updates on Table A are inserted and updated in Table B. The idea is that Table is a history table of an object. For example , I have a table called Asset where new assets are added and updated. In table B i want to record all changes made to table A. Anybody out who can help? WOuld really appreciate it.

    Thanks

    am328

  2. #2
    Join Date
    Mar 2003
    Location
    Milwaukee, WI
    Posts
    7

    Re: Insert and Update Triggers

    There are some very good trigger samples in the SQL Server Books Online documentation.

    Check out the following chapter:

    Creating and maintaining Databases\Enforcing Business Rules with Triggers\Creating Triggers

  3. #3
    Join Date
    Mar 2003
    Location
    East Grinstead ,UK
    Posts
    19

    Re: Insert and Update Triggers

    What's the URL?
    Originally posted by schustet
    There are some very good trigger samples in the SQL Server Books Online documentation.

    Check out the following chapter:

    Creating and maintaining Databases\Enforcing Business Rules with Triggers\Creating Triggers

  4. #4
    Join Date
    Mar 2003
    Location
    Milwaukee, WI
    Posts
    7
    You can access the Online books on your local system if you installed the documentation.

    The MSDN URL is:
    http://msdn.microsoft.com/library/de...es_08_3ypf.asp

  5. #5
    Join Date
    Mar 2003
    Location
    East Grinstead ,UK
    Posts
    19
    Sorry, did u mean SQL Server 2000?


    Originally posted by schustet
    You can access the Online books on your local system if you installed the documentation.

    The MSDN URL is:
    http://msdn.microsoft.com/library/de...es_08_3ypf.asp

Posting Permissions

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