How to get the sql statement that fired trigger

shreygour · #1 (**permalink**) 01-14-03, 05:06

I want to read the sql statement in trigger by which trigger is fired. Can any one help?

ridiculous · #2 (**permalink**) 07-01-09, 19:36

叼你，竟然没人回复.

aflorin27 · #3 (**permalink**) 07-02-09, 08:50

Use these steps:
- suppose you have an INSERT trigger on table A
- then your statement is something like: INSERT INTO A(...) VALUES(...)
- query the <i>inserted</i> table and you will have the values
- eliminate the NULLs
- query the data dictionary (system tables) and you will have the field names
- you are now able to re-create the entire INSERT
- why do you need it?