/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

9 votes339 views1 answer
Mysql check date range
SQL
0 vote331 views1 answer
How to drop a trigger in postgresql
SQL
1 vote336 views1 answer
Table infromation in sql server
SQL
0 vote329 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
18 votes321 views3 answers
Mysql number format
SQL
1 vote283 views1 answer
Restart identity postgresql
SQL
0 vote394 views1 answer
Generate a random otp in sql server
SQL
0 vote314 views1 answer
Oracle execute immediate quotes
SQL
0 vote411 views1 answer
Redshift running queries
SQL
28 votes353 views6 answers
Foreign key
SQL