Trigger on SELECT
Posted on 2002-03-08
Hello, I am trying to write a trigger which will allow me to intercept a SELECT statement and depending on the WHERE clause in the SELECT statement, I want to output a resultset. For example,
SELECT col FROM A WHERE x = 5;
Ordinarily, it might return
Now, if the above query executes against the server, I want to catch it before it executes and return something like
Thus, depending on where clause I wish to manipulate the resultset.