Results 1 to 2 of 2

Thread: SQL Trigger Probelm

  1. 12-01-2005, 10:40 AM #1
    jalilmon
    jalilmon is offline Registered User
    Join Date
    Dec 2005
    Posts
    11

    SQL Trigger Probelm

    I Have create a trigrer for my table transhd to update something in my detail table..

    when i updated one record the trigger works fine..

    but when i run command to update a batch of record in header
    using command [update XXXX where cont] the trigger only fire for the last record in the batch..

    is this the ms sql default behavior.. anyway to the around it

    thanks in advance
    Reply With Quote Reply With Quote
  2. 12-01-2005, 10:52 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    See answer in Ask Experts forum
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules