/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

2 votes329 views1 answer
Sqlite insert if not exists
SQL
1 vote288 views1 answer
Foreign key in oracle sql developer
SQL
1 vote322 views1 answer
Decalre temp table sql
SQL
57 votes556 views5 answers
How to create a new user in postgresql
SQL
2 votes279 views1 answer
Mysql admin u root p password change password
SQL
0 vote326 views1 answer
Mysql milliseconds
SQL
0 vote326 views1 answer
Mysql query problems and solutions
SQL
13 votes320 views6 answers
Current date sql
SQL
1 vote335 views1 answer
Create new index takes long time postgresql
SQL
0 vote308 views1 answer
How to to get current date and time in sql
SQL