/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

36 votes178 views3 answers
Finding duplicate column values in table with sql
SQL
0 vote189 views1 answer
Default column value in sql same as another column laravel
SQL
8 votes174 views1 answer
Oracle create datafile
SQL
0 vote190 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL
2 votes170 views1 answer
Plsql left() function
SQL
5 votes131 views1 answer
Mongodb vs
SQL
2 votes199 views1 answer
Python sql
SQL
1 vote227 views1 answer
Insert pg result of select
SQL
0 vote176 views1 answer
What does leave do in mysql
SQL
0 vote171 views1 answer
How to check xampp mysql password
SQL