What are the challenges you face when working across database platforms? Take the survey
Options

Encapsulate as new stored procedure not generating output parameters

GeoRewindGeoRewind Posts: 2 Bronze 1
edited June 21, 2018 8:42PM in SQL Prompt
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
Tagged:

Answers

Sign In or Register to comment.