MSSQL Triggers
-
hi , i would like to fire set of queries when a select query is fired on to particular table, can any one help in this ..
-
hi , i would like to fire set of queries when a select query is fired on to particular table, can any one help in this ..
As far as I know, this can't be done with triggers if that is what you are thinking. Why don't you create a stored procedure which does your "queries" and have the applications use that stored procedure instead of directly accessing the table ? Just a thought.
-
hi , i would like to fire set of queries when a select query is fired on to particular table, can any one help in this ..
Triggers are valid for events, select is not considered an event. Besides triggers are EVIL :mad:. I'm curious as to the requirement for a trigger on a select, why do you need it
Never underestimate the power of human stupidity RAH