/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 vote343 views1 answer
Sql contains vs like
SQL
0 vote372 views1 answer
Exit psql
SQL
5 votes356 views2 answers
Mysql create database charset utf8mb4
SQL
-1 vote331 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
4 votes390 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
0 vote390 views1 answer
Sql set data from a select query to a temp table and insert
SQL
6 votes367 views2 answers
Mysql 1 day ago
SQL
0 vote326 views1 answer
Create domain sql
SQL
2 votes347 views1 answer
Update trigger
SQL
32 votes434 views6 answers
Rename column mysql
SQL