/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

1 vote353 views2 answers
Oracle list partitioned tables
SQL
0 vote349 views1 answer
T sql return on letters only
SQL
0 vote345 views1 answer
Json_remove mysql
SQL
3 votes370 views5 answers
Foreign keys
SQL
2 votes389 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
1 vote361 views1 answer
$query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query))
SQL
0 vote388 views2 answers
Replace null with 0 in sql
SQL
4 votes367 views3 answers
Copy table postgres
SQL
0 vote358 views1 answer
Replace string in whole database mysql stackoverflow
SQL
0 vote354 views1 answer
Pgadmin see indexes
SQL