/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

1 vote316 views1 answer
How to get previous year from sysdate in oracle
SQL
0 vote305 views1 answer
Mysql query to add hours to column in table
SQL
0 vote293 views3 answers
Mysqli count down
SQL
0 vote316 views1 answer
Code to move ietms from one table to another myswl
SQL
3 votes331 views1 answer
Sql print all names that start with a given letter
SQL
4 votes315 views2 answers
REST API
SQL
-2 votes320 views1 answer
Trunc in sql
SQL
0 vote292 views1 answer
Select top 3 sql
SQL
1 vote315 views1 answer
Vagrant mysql downgrade version
SQL
0 vote343 views2 answers
How to truncate all table in mysql workbench
SQL