/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 vote274 views1 answer
We are intrested to work with your organization
SQL
1 vote287 views1 answer
List all triggers in SQL Server
SQL
1 vote284 views1 answer
Insert column after column mysql
SQL
2 votes302 views5 answers
Eloquest how to select one specific column in database
SQL
3 votes293 views1 answer
Postgres add not null to existing column
SQL
1 vote281 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote290 views1 answer
Oracle current timestamp
SQL
0 vote290 views1 answer
Product of a column in mysql
SQL
1 vote273 views1 answer
Mysql Case sum
SQL
0 vote275 views1 answer
How to query all tables mysql at the same time
SQL