Answers for "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

Posted by: Guest on January-06-2022

Code answers related to "sql trigger to call stored procedure with parameters"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "sql trigger to call stored procedure with parameters"

Code answers related to "sql trigger to call stored procedure with parameters"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "sql trigger to call stored procedure with parameters"

Code answers related to "sql trigger to call stored procedure with parameters"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us