Hello

Is there any possibilities to pass parameters to Triggers if so How?.

Siva.

No, what is the purpose?

Show quoteHide quote

I dont think it is possible.

Triggers can use 2 system tables inserted and deleted to see what rows where
affected on the table.


Show quoteHide quote

You cannot send data as parameters to triggers, you can, however, create a
global temporary table outside the trigger, insert the data into that table,
then retrieve the data in the trigger as appropriate.

But most importatntly (as the other poster have already asked) - why?


ML

---
http://milambda.blogspot.com/

Activity Monitor
Left Joins (*=)
IN operator versus BETWEEN and >= AND <=
Pass two parameters in query
Newbie question on BULK INSERT of text file