/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 vote149 views1 answer
Sqlserver now
SQL
-1 vote142 views3 answers
How to restart mysql in linux
SQL
1 vote183 views1 answer
Psql client write to bash variable
SQL
2 votes134 views1 answer
Sql update from different table
SQL
1 vote120 views1 answer
Sql convert month name to number
SQL
0 vote147 views1 answer
Sql server concat null
SQL
16 votes155 views3 answers
Get count of duplicate records
SQL
0 vote131 views1 answer
Oracle free up space in tablespace
SQL
1 vote244 views1 answer
Mysql data from file
SQL
49 votes227 views6 answers
Mysql add column to table
SQL