Is it possible to send a message that can be used in trigger code?
Something like
CREATE TRIGGER MyTrigger ON MyTable
AFTER INSERT
AS BEGIN
INSERT INTO AnotherTable (Col, TheMessage)
SELECT Col, TRIGGER_MESSAGE FROM inserted -- TRIGGER_MESSAGE contains 'Hey, its me'
END
INSERT INTO MyTable (Col) VALUES (1) TRIGGER_MESSAGE 'Hey, its me'
You need to sign in to view this answers