/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 vote125 views1 answer
Grant privileges mysql to database 1064
SQL
1 vote198 views1 answer
Athena query timestamp greater than
SQL
0 vote118 views1 answer
Create sql table from script inline primary key constraint
SQL
0 vote130 views1 answer
SQL Cut part string
SQL
1 vote116 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL
0 vote149 views1 answer
Query only first letter string
SQL
11 votes116 views2 answers
Oracle all source
SQL
3 votes109 views1 answer
How to remove characters from string in mysql
SQL
0 vote121 views2 answers
Oracle select
SQL
0 vote105 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL