/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 vote306 views1 answer
Duplicate foreign key constraint name
SQL
0 vote331 views2 answers
How to update the multiple rows in sql
SQL
7 votes305 views1 answer
Mysql load data infile csv
SQL
-2 votes349 views1 answer
Trunc in sql
SQL
0 vote281 views1 answer
Ms sql print more than 1 variable
SQL
0 vote340 views1 answer
Connect to ssms with python
SQL
0 vote343 views1 answer
Postgresql get diff between two dates in Months
SQL
1 vote330 views3 answers
Reset sql primary key
SQL
1 vote301 views1 answer
Psql show with user is logged in
SQL
0 vote317 views1 answer
Html css mobile menu arrow dropdown
SQL