/SQL/Sql trigger to call stored procedure with parameters

Sql trigger to call stored procedure with parameters

 DECLARE @OrderNumber NVARCHAR(150);
 IF EXISTS(SELECT * FROM INSERTED)
    BEGIN
    SELECT @OrderNumber=i.OrderNumber FROM inserted i;
 	EXEC [dbo].[YOUR_STOREPROCEDURENAME]
          @InGuidKey = N'',
          @InParameter1 = '',
		 @InParameter2 = '',
         @InDebugModeOn = N'0'
    END

Similar codes

0 vote237 views1 answer
Every Derived yable must have its own alias
SQL
2 votes242 views1 answer
Postgresql transaction
SQL
0 vote229 views1 answer
How to define a save method in ruby for sql databases
SQL
0 vote297 views1 answer
Oracle simple quote
SQL
3 votes242 views2 answers
MySQL query to get column names
SQL
0 vote225 views1 answer
Changer un mot de passe mysql
SQL
0 vote188 views1 answer
Finish transaction sql
SQL
0 vote257 views1 answer
Firebase sql
SQL
0 vote342 views1 answer
Sql insert exemplo
SQL
0 vote251 views1 answer
How to find table lock and row lock in mysql
SQL