Is it possible to add the reverse feature of inline exec?

• 
  Hi ogrishman,
  
  So there may be a feature that does what you mean. If you select some SQL and press the Ctrl key to open up the actions list, you can find Encapsulate as stored procedure:
  
  
  
  Then you get a script like this:
  
  
  
  Is this the kind of thing you're looking for?
  
  Best regards,
  
  David

  David Priddle November 25, 2016 06:57

  - 0 +
• 
  No David, that's not what I want. Basically "inline execute" converts something like
  

  DECLARE @input INT = 10;
  DECLARE @output INT;
  
  EXEC sys.sp_executesql
      N'SELECT @output = @input',
      N'@input INT, @output INT out',
      @input = @input,
      @output = @output OUT;
  

  
  To
  

  DECLARE @input1 INT;
  SET @input1 = @input;
  SELECT @output = @input1
  

  
  What I want is a feature to wrap a piece of code in sp_executesql.
  
  Thanks and happy Thanksgiving!

  ogrishman November 25, 2016 08:59

  - 0 +
• 
  Hi ogrishman,
  
  I see where you're coming from.
  
  At the moment we don't have this functionality. Would you be able to add it as a feature suggestion on our UserVoice page?
  
  Best regards,
  
  David

  David Priddle November 28, 2016 04:16

  - 0 +

Add comment

Please sign in to leave a comment.