bingo/sqlserver/Resources/OnUpdateTrigger.sql

CREATE TRIGGER {0}
	ON {1}
	FOR UPDATE
AS
	IF UPDATE({2}) 
	BEGIN 
		RAISERROR ('{2} column cannot be changed after Bingo index has been created.', 16, 1);
		ROLLBACK TRANSACTION
	END
	
	IF NOT UPDATE({3}) 
	BEGIN 
		RETURN 
	END
	
	IF OBJECT_ID('tempdb..##bingotmptbl_{5}_{6}') IS NOT NULL
	BEGIN
		DROP TABLE ##bingotmptbl_{5}_{6}
	END
	select {2}, {3} into ##bingotmptbl_{5}_{6} from inserted 

	exec {4}._OnDeleteRecordTrigger {5}, {6}, '##bingotmptbl_{5}_{6}'
	exec {4}._OnInsertRecordTrigger {5}, {6}, '##bingotmptbl_{5}_{6}'
	DROP TABLE ##bingotmptbl_{5}_{6}