Make Trigger run update after Procedure has been run

Asked

Viewed 324 times

1

I would like to know how I do in SQL Server for a Trigger check if the trial was executed and if it was executed, this Rigger will do another update. Thanks for your attention.

Att, Marcilio

sql sql-server

  • Trigger is only on command INSERT and/or DELETE and/or UPDATE. There is no Rigger on top of Procedure(even because it doesn’t make sense, it’s easier to just add something at the end of it)

  • @DH. I get it, but on my Trigger I’m going to use exec.dbo.nomeproc and then perform an update, can’t I do that? I couldn’t find an example on the Internet

  • Detail the problem, maybe we can model a solution, you’re "almost" with a solution looking for a problem.

1 answer

1

Because the update is not performed within the process?

Trigger is a reaction to a DDL or DML command.

Browser other questions tagged sql sql-server

You are not signed in. Login or sign up in order to post.