/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

1 vote184 views4 answers
Sql now
SQL
0 vote215 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
0 vote202 views1 answer
Mysql sum per week
SQL
0 vote194 views1 answer
Mysql select inside sum
SQL
0 vote213 views1 answer
How to remove quotes from a string in ssis load file
SQL
0 vote207 views1 answer
To Create directory
SQL
4 votes203 views4 answers
Pl sql output
SQL
0 vote190 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
0 vote227 views1 answer
Alternative for LIMIT sql
SQL
1 vote202 views1 answer
Query for all indexes in table postgres
SQL