Suppose I have a very simple stored procedure
, which performs a select
, but I want to make a trigger
that is activated every time I use that stored procedure
. Does anyone know exactly how to do something like that?
We could say that the body of my procedure is:
SELECT TOP (1000) [x]
,[y]
,[z]
,[x1]
FROM tx
where xy = @xy