/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

3 votes145 views2 answers
Mysql HAVING
SQL
2 votes168 views2 answers
Postgres timestamp to datetime
SQL
0 vote130 views1 answer
Find how many table doesn't contain column in mysql
SQL
0 vote149 views1 answer
Raiserror with nowait
SQL
2 votes155 views1 answer
Docker run postgres locally
SQL
0 vote148 views1 answer
How to insert multiple rows in mysql using laravel
SQL
-1 vote135 views1 answer
Sql getdate date only
SQL
1 vote165 views1 answer
How to give access to database in postgresql server to another user
SQL
32 votes149 views6 answers
Sql count where
SQL
13 votes145 views2 answers
Get date from now() mysql
SQL