/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 vote211 views2 answers
Identity column in sql server
SQL
2 votes186 views3 answers
Mysql cheat sheet
SQL
0 vote264 views1 answer
Connect google bigquery connect using sqirrel
SQL
7 votes231 views2 answers
Sql remove duplicates based on column
SQL
0 vote193 views1 answer
Sql select min row
SQL
0 vote181 views1 answer
Postgresql inline table
SQL
6 votes203 views1 answer
Phpmyadmin password root
SQL
19 votes203 views2 answers
Mysql add column after another
SQL
0 vote230 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
0 vote201 views3 answers
Get free card roblox
SQL