Creating triggers

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » General » Creating triggers

Creating triggers

Rate Topic

Display Mode

Topic Options

Author

Message

Tammy Robinson

Posted Thursday, January 31, 2008 8:47 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, October 16, 2012 7:46 AM
Points: 31, Visits: 37

I need a little help with creating trigger. I am trying to update a particular field in one table after a change is made to a field in another table.

Here is the scenario:

A user will update a field;this field will become a null value. At this point, I would like a field in another table to become blank.

I think my issue is that the table that is being updated by the user does not directly link to the table being updated after the trigger.

Here is what I have:

CREATE TRIGGER reset_Assign
ON 1sttable FOR UPDATE
AS

Begin

IF update(hCurrentCamRule) /*field from 1sttable */
IF NULL = (Select i.hCurrentCamRule From inserted i)
IF 'Garage' = (Select i.sDesc from Inserted i)
IF Exists (Select * from 2ndtable b Inner join inserted i2 on i2.hCurrentCamRule = b.hMy
join 3rdtable c on c.hCode = b.htenant)
UPDATE 3rdtable set sfield = ''
From 3rdtable c2 Join 2ndtable b2 on c2.hCode = b2.htenant join inserted i3 on i3.hCurrentCamRule = b2.hMy

END

Any help would be appreciated.

Thanks!

Post #450001

« Prev Topic | Next Topic »

Permissions