Update trigger consistency

Last Post 25 Oct 2007 10:32 PM by SwePeso. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
timcronin
New Member
New Member

--
25 Oct 2007 08:32 AM
I have an update trigger on a table with 2 field names. When these 2 fields are updated I have an update trigger which fires which will update 4 patient tables in 4 other databases. If this update to these fields is going to be done through a join ie below, should I expect the trigger to update the underlying tables, or do I need to cursor throught the updates

update patient_master
set location = location from fixtable where fixtable.id = patient_master.id
SwePeso
New Member
New Member

--
25 Oct 2007 10:32 PM
I think you should involve the virtual table INSERTED to only update those records affected in last update or insert operation.
You are not authorized to post a reply.

Acceptable Use Policy