SQL Server Procedure with Encryption input Parameter

Question

I am new at using procedure with encryption, I tried altering my procedures to encrytped procedure. When there is no input parameter something like,

ALTER PROCEDURE [dbo].[Stock] WITH ENCRYPTION
     -- @Input_Parameter1 nvarchar(50) -> gives syntax error
AS
BEGIN
    SET NOCOUNT ON;

    select * from Inventory
END

It works. But when I add some input parameters between WITH ENCRYPTION and as it throws an error. How can I do that ?

wiretext · Accepted Answer · 2015-10-13 12:23:09Z

4

just you miss syntaxes

CREATE PROCEDURE [dbo].[Stock] 
@Input_Parameter1 nvarchar(50) --> gives syntax error
WITH ENCRYPTION
...

answered Oct 13, 2015 at 12:23

wiretext

3,35216 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

wiretext Over a year ago

@AliCAKIL glad it helps you

Dan Guzman · Accepted Answer · 2015-10-13 12:23:09Z

2

The WITH ENCRYPTION clause needs to be specified after the parameter declarations:

ALTER PROCEDURE [dbo].[Stock] 

@Input_Parameter1 nvarchar(50) 

WITH ENCRYPTION

AS

BEGIN

SET NOCOUNT ON;

SELECT * FROM dbo.Inventory;

END;

answered Oct 13, 2015 at 12:23

Dan Guzman

46.8k3 gold badges52 silver badges77 bronze badges

Collectives™ on Stack Overflow

SQL Server Procedure with Encryption input Parameter

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related