Can I pass a parameter to run in a SQL Server database?

Question

A table may have a trigger when inserting / deleting / updating. The trigger will be launched internally using the database engine.

Can I pass a parameter to run in a SQL Server database, for example, a stored procedure?

Answer 1

Indirectly through CONTEXT_INFO(). See Using session context information . The fact that your trigger requires an extra state is always the smell of code.

Answer 2

Nope.

See: http://www.eggheadcafe.com/community/aspnet/13/10006230/pass-values-in-trigger.aspx

Answer 3

. , , , . .

, :

• . , .
• , , . , , .