Professional Web Applications Themes

how to write FOR EACH ROW trigger? - Microsoft SQL / MS SQL Server

i have a after update trigger which perform upadte on a summary table. sometimes, the number of affected records is more than one. but the trigger only be excuted once. i want to implement 'FOR EACH ROW' trigger like Oracle does in SQL server. anyone got idea? instead of writing a cursor to perform the update row by row....

  1. #1

    Default how to write FOR EACH ROW trigger?

    i have a after update trigger which perform upadte on a
    summary table.

    sometimes, the number of affected records is more than one.
    but the trigger only be excuted once.

    i want to implement 'FOR EACH ROW' trigger like Oracle
    does in SQL server.
    anyone got idea?

    instead of writing a cursor to perform the update row by
    row.
    Nel Guest

  2. #2

    Default Re: how to write FOR EACH ROW trigger?

    There is no FOR EACH option in SQL Server. The pseudo tables that get
    created in the triggers aculate all the changes done. Maybe if you post
    what summary update needs to be done, we can possibly give you a solution
    that removes the usage of cursors.
    --
    HTH,
    SriSamp
    Please reply to the whole group only!
    http://www32.brinkster.com/srisamp

    "Nel" <org> wrote in message
    news:045001c349d7$92b77a00$gbl... 


    SriSamp Guest

Similar Threads

  1. XML.TRIGGER
    By Dan-C in forum Macromedia Flash Data Integration
    Replies: 1
    Last Post: February 28th, 03:55 PM
  2. Trigger
    By James in forum ASP Database
    Replies: 1
    Last Post: August 6th, 01:05 AM
  3. Replies: 2
    Last Post: June 1st, 08:38 PM
  4. Trigger Help
    By Mike in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: July 9th, 07:28 PM
  5. Trigger key
    By Elisabeth Smith in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: July 2nd, 09:22 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139