Encapsulate as new stored procedure not generating output parameters
GeoRewind
Posts: 2 Bronze 1
Hello, I am using SQL Prompt version 9.1.16.5356 with SSMS2014, ever since i made the SQL Prompt update, the encapsulated into stored procedure option does not produce the required parameters. I restarted my PC and tried the repair SQL Prompt under programs and features but I am still not getting desired outcome.
--I highlighted the select statement and clicked on the encapsulate as new store procedure
SELECT @Yes=1, @no=0
Results
Encapsulation Created By SQL Prompt
CREATE PROCEDURE dbo.EncapsulatedProcedure AS
--No output parameters are being generated here
Results
Encapsulation Created By SQL Prompt
CREATE PROCEDURE dbo.EncapsulatedProcedure AS
--No output parameters are being generated here
BEGIN
DECLARE @Yes BIT ;
DECLARE @No BIT ;
END
Tagged:
Answers
Thanks for your post.
I can see that you have resolved this already through a support ticket.
Best
Richard Lynch.
Redgate Software