/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 vote349 views1 answer
SQL Cut part string
SQL
1 vote312 views1 answer
Postgres first_value in gropby
SQL
0 vote351 views1 answer
SQL server datetime compare
SQL
0 vote317 views1 answer
Sql get month from date
SQL
2 votes362 views1 answer
How to check if a row is null in sql
SQL
4 votes297 views2 answers
Oracle unliock account
SQL
0 vote320 views1 answer
How to move a column to different spot mysql
SQL
0 vote336 views1 answer
Mysql best varchar length size
SQL
4 votes352 views6 answers
List all tables in postgres
SQL
4 votes316 views3 answers
Drop Table Oracle
SQL