/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

41 votes380 views6 answers
Alter table add column in SQL Server
SQL
1 vote308 views1 answer
Oracle select row max date
SQL
1 vote323 views1 answer
Dropping a constraint in ms sql
SQL
2 votes314 views4 answers
Check timezone of mysql database
SQL
0 vote299 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL
5 votes279 views2 answers
Ranking functions in sql
SQL
0 vote304 views1 answer
How to see password mysql vestacp
SQL
0 vote348 views1 answer
Sql server query all database objects
SQL
2 votes286 views2 answers
Useradd postgres
SQL
0 vote285 views1 answer
Display first three characters sql
SQL