/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 vote186 views3 answers
Nth highest salary
SQL
0 vote167 views1 answer
Sql server update top n records
SQL
24 votes181 views6 answers
Rename a column in sql server
SQL
2 votes175 views3 answers
Sql server reseed identity column
SQL
1 vote172 views1 answer
Grab all records from one table to another oracle sql
SQL
1 vote182 views1 answer
Mysql show database size in mb
SQL
0 vote186 views1 answer
Sql statement show all emails with dome
SQL
2 votes176 views1 answer
Sql column values comma separated
SQL
0 vote229 views1 answer
ALV GRID events
SQL
6 votes169 views1 answer
SQL insert all columns
SQL