/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 vote156 views2 answers
Sql trigger difference between for and after
SQL
23 votes156 views1 answer
How remove column in mysql
SQL
34 votes176 views6 answers
Install mysql client ubuntu
SQL
1 vote142 views1 answer
Show table columns
SQL
0 vote139 views1 answer
Django how to get query result count
SQL
3 votes152 views3 answers
How to set up an auto incrementing id db browser
SQL
15 votes167 views4 answers
Export mysql db using command line
SQL
13 votes104 views2 answers
Oracle all source
SQL
0 vote275 views1 answer
Oracle convert int to date
SQL
0 vote155 views1 answer
Postgresql in vs any performance
SQL