/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 vote111 views1 answer
Get only one row in mysql
SQL
0 vote99 views1 answer
Mysql select where text contains
SQL
1 vote122 views1 answer
Alter constraint in sql
SQL
1 vote98 views1 answer
What is int in mysql
SQL
79 votes273 views6 answers
Grepper code
SQL
0 vote115 views1 answer
Duplix print in Smartforms
SQL
8 votes122 views1 answer
Mac restore mysql database command line
SQL
0 vote100 views1 answer
SQL server select to get sum of hours
SQL
13 votes140 views3 answers
List all the tables in sql
SQL
2 votes114 views1 answer
Date conversion in mysql column
SQL