/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 vote244 views1 answer
How to check if there is no database schema
SQL
2 votes256 views1 answer
Set column to not null mysql
SQL
6 votes265 views1 answer
Oracle rank
SQL
0 vote274 views1 answer
Select sql in descending order
SQL
0 vote270 views2 answers
Mysql set foreign_key_checks=0
SQL
0 vote239 views1 answer
How to to get current date and time in sql
SQL
3 votes279 views3 answers
Mysql auto increment after delete
SQL
0 vote257 views1 answer
When mysql server would not work in xampp
SQL
8 votes272 views2 answers
Sqlsrv default port
SQL
0 vote268 views1 answer
Change date in pivot table to month in sql server
SQL