Does anyone know how to reference a input parameter that is passed into a stored procedure from a trigger?
Say if I have an 'insert' statement that accepts input parameters from user, that insert statement in turn fires an insert trigger which require to use the input parameter passed into that store procedure. How can it be achieved? What's the syntax for it? Please show me an example if you can, thanks a lot.