/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 vote218 views1 answer
Create table in dbms cmds
SQL
0 vote217 views1 answer
Basic structure of sql expression having clause
SQL
0 vote221 views1 answer
Postgres create extension if not exists
SQL
0 vote218 views1 answer
Copy row from db to db mysql
SQL
0 vote240 views2 answers
Mysql show foreign keys
SQL
6 votes233 views1 answer
Oracle pl sql source
SQL
0 vote222 views1 answer
Get schema of table sql
SQL
0 vote212 views4 answers
Forenkey code alchemy sql
SQL
3 votes304 views1 answer
Oracle cannot access v$session
SQL
0 vote234 views1 answer
T-sql delete view if exists
SQL