/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

5 votes171 views1 answer
Sql asynchronous stored procedure call
SQL
0 vote187 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
0 vote180 views2 answers
Imageview setimageresource null
SQL
1 vote194 views1 answer
Mysql month name extract
SQL
0 vote169 views1 answer
Drop all tables in azure sql database
SQL
0 vote189 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
13 votes190 views3 answers
Change data type postgresql
SQL
1 vote209 views1 answer
Postgres install unaccent extension
SQL
0 vote176 views1 answer
Sql constarint
SQL
3 votes254 views1 answer
Oracle apex warn on unsaved changes
SQL