/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 vote95 views1 answer
View acl table oracle
SQL
5 votes118 views4 answers
SQL Order of execution
SQL
1 vote120 views3 answers
Connection string mysql
SQL
1 vote131 views1 answer
Count of tables in database mysql
SQL
2 votes103 views1 answer
Sql alchemy or
SQL
4 votes96 views2 answers
Sql server date now
SQL
0 vote110 views1 answer
Hibernate with springboot mysql
SQL
-2 votes96 views1 answer
How to open database
SQL
1 vote104 views1 answer
Postgresql escape single quote
SQL
0 vote106 views1 answer
How to find sql server name
SQL