[dba-SQLServer]Update Trigger

Nicholson, Karen knicholson at gpsx.net
Fri May 23 14:13:15 CDT 2003


I need to create an update trigger on a table to update a field in another
table.  This is the scope:

Originating table: 	System  /**I did not name it, proprietary package**/
Field:			CS_No 
Key Field:		Site_no

Destination Table:	Recur_Line
Field:			UDF1CS_no
Key Field:		Service_Site_No

Scenario:  When the user is in the system, he enters in a CS_No in the
table(System) field(CS_No).
I need this to populate the UDF1CS_no field in the Recur_Line table

when the System.Site_no=Recur_Line.SiteNo

This is my first "cross pollinating" trigger as I refer to it.  Does anyone
have an example?  Thanks, gurus.		
		
Karen Nicholson
SQL Database Administrator
Guardian Protection Services



More information about the dba-SQLServer mailing list