ALTER TRIGGER Alabama_ID_UPDATE_USERBRDG_ON_NEW_BRIDGE ON STRUCTURE_UNIT.STRUNITKEY
AFTER  INSERT , UPDATE 
AS
FOR EACH ROW



--IF EXISTS(SELECT *
--	FROM INSPEVNT
--	JOIN INSERTED ON
--	INSPEVNT.BRKEY = INSERTED.BRKEY
--	WHERE INSPEVNT.BRKEY = INSERTED.BRKEY)


BEGIN
--SET NOCOUNT ON
--IF (UPDATE(STRUNITKEY))
BEGIN
DECLARE @BRKEY VARCHAR(15)				
	SET @BRKEY = (SELECT BRKEY FROM inserted)  
DECLARE @ALABAMA_ID VARCHAR(20)
        SET @ALABAMA_ID = (SELECT ALABAMA_ID FROM USERBRDG WHERE USERBRDG.BRKEY = @BRKEY)   
BEGIN
IF(@ALABAMA_ID IS  NULL)  
SET @ALABAMA_ID = ('XXXXXXXXXXXXXXXXXXX')
END
UPDATE USERBRDG SET USERBRDG.ALABAMA_ID = @ALABAMA_ID WHERE USERBRDG.BRKEY =  @BRKEY 
END  
END

GO

quote:

---

Trigger on an INSERT, UPDATE, or DELETE statement to a table or view (DML Trigger)
CREATE TRIGGER [ schema_name . ]trigger_name 
ON { table | view } 
[ WITH <dml_trigger_option> [ ,...n ] ]
{ FOR | AFTER | INSTEAD OF } 
{ [ INSERT ] [ , ] [ UPDATE ] [ , ] [ DELETE ] }
[ NOT FOR REPLICATION ] 
AS { sql_statement  [ ; ] [ ,...n ] | EXTERNAL NAME <method specifier [ ; ] > }

<dml_trigger_option> ::=
    [ ENCRYPTION ]
    [ EXECUTE AS Clause ]

<method_specifier> ::=
    assembly_name.class_name.method_name

---