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.
Test Code
DECLARE @Yes BIT , @No BIT
--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
BEGIN
DECLARE @Yes BIT ;
DECLARE @No BIT ;
SELECT @Yes=1, @no=0
END
Test Code
DECLARE @Yes BIT , @No BIT
--I highlighted the select statement and clicked on the encapsulate as new store procedure
Results
Encapsulation Created By SQL Prompt
CREATE PROCEDURE dbo.EncapsulatedProcedure AS
--No output parameters are being generated here