/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 vote222 views2 answers
How to see table associated with a schema in sql
SQL
0 vote221 views2 answers
Get item by composite primary key mysql
SQL
1 vote215 views1 answer
Sql row having max
SQL
4 votes198 views1 answer
Oracle session date format
SQL
0 vote232 views1 answer
Sql file in postgres with pgadmin
SQL
0 vote197 views1 answer
Flask sqlalchemy update row
SQL
15 votes319 views4 answers
Mysql export database command line
SQL
1 vote198 views1 answer
Database Queries
SQL
0 vote199 views1 answer
Mysql does collate nopad recognize space
SQL
0 vote201 views1 answer
T-sql email validation
SQL