/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

3 votes129 views1 answer
Oracle rollback
SQL
0 vote118 views1 answer
Dump multiple tables mysql
SQL
1 vote125 views1 answer
Psql: FATAL: Ident authentication failed for user "postgres"
SQL
1 vote131 views2 answers
Postgresql backup and restore globals and data
SQL
0 vote116 views1 answer
How change the field place in mysql
SQL
0 vote144 views1 answer
Check database restore status sql script
SQL
1 vote139 views4 answers
Mysqldump 1 table only
SQL
0 vote147 views1 answer
Dual in db2
SQL
-1 vote147 views1 answer
Mysql coalesce
SQL
3 votes138 views1 answer
Oracle user privileges
SQL