/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 vote187 views1 answer
Sql count more than 1
SQL
0 vote173 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
0 vote3.6K views1 answer
PSQL use LIKE with timestamps
SQL
0 vote182 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
3 votes173 views1 answer
Oracle list dates without weekends
SQL
5 votes230 views1 answer
Dbms_metadata.get_ddl table
SQL
0 vote199 views1 answer
Dual in db2
SQL
0 vote185 views2 answers
Null value in column violates not-null constraint
SQL
1 vote194 views1 answer
Drop primary key oracle
SQL
1 vote184 views1 answer
GROUP BY clause; this is incompati
SQL