/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 vote131 views1 answer
Power query case when
SQL
0 vote151 views1 answer
Insert or update sql firebird
SQL
0 vote140 views1 answer
List all indexes postgres
SQL
3 votes163 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
0 vote139 views1 answer
Query to get all primary keys and foreign key
SQL
5 votes146 views1 answer
Sql table columns
SQL
0 vote204 views1 answer
Sql delete row from table where id
SQL
2 votes167 views2 answers
How to check data type in sql server
SQL
0 vote143 views2 answers
Sql server set default value equal to auto increment
SQL
0 vote137 views1 answer
How to get inserted id in sql server
SQL