SQL Prompt is 7.3 beta (now closed)

• 
  FYI: All the UserVoice links for the "And many more" list are pointing to your admin portal for UserVoice.

  dslinn August 22, 2016 12:57

  - 0 +
• 
  Hi dslinn,
  
  Thanks for letting us know! The links should be fixed now.
  
  Thanks,
  Aaron.

  Aaron L August 22, 2016 13:01

  - 0 +
• 
  Blank lines being introduced in set statements inside a multi-statement table function.
  
  
  
  Current version 7.3.0.450 (at time of post most recent. Issue currently till exists)

  sheldonhull August 24, 2016 12:11

  - 0 +
• 
  Hi Sheldon,
  
  We've got a fix in that should resolve this issue, we'll look into getting this released soon.
  
  Best regards,
  
  David

  David Priddle August 25, 2016 03:19

  - 0 +
• 
  Hi Sheldon,
  
  We've just released this fix as part of our new build, could you download it and let us know if it solves your problem?
  
  Best regards,
  
  David

  David Priddle August 25, 2016 09:04

  - 0 +
• 
  I have a query that is over 2000 lines long and when I go to 'Format SQL' it won't run as it says "Error laying out sql" and it highlights the first letter in the first line of the SQL. However, if I run the format command on individual parts of the statement in sections, it works fine. It just doesn't work when it is run across the entire script. This did not occur before I updated to the 7.3 beta. It occurred on 7.3.450 and 7.3.460. I should also mention that the entire script can be run against SQL just fine, so there is not a syntax issue with the script.

  hafnera August 26, 2016 10:52

  - 0 +
• 
  I love the new "Inline Stored Procedure" functionality. However, it appears it is only available when you right click on the name of the SP when you have EXEC <SP Name>. It would be nice if you could initiate this functionality any time you reference the stored procedure. So if it is proceeded by 'ALTER PROCEDURE', 'CREATE PROC', or if you right click on the stored procedure from within the SSMS tree (ie Server>Databaseses>DatabaseName>Programmability>Stored Procedures). I don't know if this is something to put on UserVoice or if it could be added as part of the existing request and included in the next Beta? Just a thought.

  hafnera August 26, 2016 14:37

  - 0 +
• 
  Hi hafnera,
  
  Would it be possible to send the script or a small script that can reproduce the formatting problem to me at david.priddle@red-gate.com?
  
  For the second question, would Script as Alter (F12) do what you want? Otherwise, you can hover over the stored procedure name to get the backing script.
  
  Best regards,
  
  David

  David Priddle August 30, 2016 05:08

  - 0 +
• 
  Tabs are sometimes added after alias names. Occurrences have been noticed where the tab is added either in front or following the . operator separating the table name from the column name. Occurrences seem to happen on lengthy scripts.
  
  Example fragment:

  WHERE		t.	BusWeek BETWEEN @ReportStart AND @ReportEnd
  

  
  Example 2 fragment (Issue shows up in both lines 6 and 8 - notice the tab can be prior to or after the . operator:

  FROM	dbo.PA10702 PA_PO_ReceiptLine
  		LEFT JOIN dbo.PA01201 PA_Project_MSTR ON PA_PO_ReceiptLine.PAPROJNUMBER = PA_Project_MSTR.PAPROJNUMBER
  		LEFT JOIN dbo.PA01101 PA_Contract_MSTR ON PA_Project_MSTR.PACONTNUMBER = PA_Contract_MSTR.PACONTNUMBER
  		INNER JOIN dbo.PA01001 PA_Cost_Category_MSTR ON PA_PO_ReceiptLine.PACOSTCATID = PA_Cost_Category_MSTR.PACOSTCATID
  		LEFT JOIN dbo.PA01601 PA_ReceiptLine_Billing_Notes
  			ON	PA_PO_ReceiptLine.	PAbillnoteidx = PA_ReceiptLine_Billing_Notes.PAbillnoteidx
  		INNER JOIN DYNAMICS.dbo.MC40200 MC_Currency_SETP
  			ON	PA_PO_ReceiptLine	.PAMCCURNCYID = MC_Currency_SETP.CURNCYID;
  

  Bryan H August 30, 2016 13:17

  - 0 +
• 
  Hi Bryan,
  
  Thanks for your post, we have a fix internally and should be releasing a new beta build soon.
  
  Our support team mentioned you opened a ticket with them to get this fixed too - please keep in mind it is still a beta version and will contain some bugs. You can switch back to the stable formatter at any time by unchecking the "Use new formatting styles" checkbox on the experimental features page.
  
  Sorry for the slow response - we had missed your post as it got lost in the announcement thread. I'll lock this thread to avoid it happening in the future.
  
  Thanks,
  Aaron.

  Aaron L September 05, 2016 05:22

  - 0 +

Add comment

Please sign in to leave a comment.