/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 votes307 views3 answers
Row number mysql
SQL
0 vote271 views1 answer
Query to insert image
SQL
2 votes249 views1 answer
Foreign key example in dbms
SQL
0 vote281 views1 answer
Db format in quotation
SQL
4 votes306 views1 answer
Oracle nls_date_format
SQL
0 vote229 views1 answer
Import csv to mysql
SQL
-1 vote281 views1 answer
Mysql change database charset and collation
SQL
0 vote269 views1 answer
Find number of entries sql
SQL
0 vote261 views1 answer
Check index sql server
SQL
0 vote274 views1 answer
Sql column as header
SQL