/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 vote114 views0 answer
SQL
0 vote187 views1 answer
How to find sql server name
SQL
4 votes157 views2 answers
Sql offset
SQL
1 vote146 views1 answer
Mysql best tutorial for beginners
SQL
7 votes154 views4 answers
Index in mysql
SQL
1 vote201 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
7 votes209 views2 answers
Oracle foreign key reference table
SQL
0 vote171 views1 answer
Except in sql
SQL
16 votes174 views5 answers
Select last row in sql
SQL
0 vote143 views3 answers
Average salary in sql
SQL