/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

7 votes111 views6 answers
Reset identity column in sql server
SQL
0 vote124 views1 answer
Connect by query in oracle
SQL
0 vote107 views1 answer
Automate mysql cli query
SQL
0 vote121 views1 answer
SQL add a totals of differemt rows of the same id
SQL
1 vote107 views1 answer
How to delete data from sql database in android
SQL
7 votes123 views2 answers
N highest salary in sql
SQL
1 vote120 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
4 votes118 views2 answers
Oracle drop job
SQL
8 votes111 views1 answer
Alter tablespace add datafile
SQL
0 vote139 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL