Options
Bug - with Recompile
torsten.strauss
Friend of Redgate › Posts: 266 Silver 3
in SQL Prompt
Hi Redgate Team
SQLPrompt cannot format the following code.
Would be great to see a fix in the next release!
Thanks!
Torsten
MVP
SQLPrompt cannot format the following code.
DECLARE @StatementAllTransactions nvarchar(4000)
DECLARE @ParameterDefintionAllTransactions nvarchar(4000)
DECLARE @_ParentAuthorityId int
INSERT dbo.mTransactions
(
OPUCode
)
EXECUTE sp_executesql
, @_ParentAuthorityId = 1
WITH RECOMPILE;
Would be great to see a fix in the next release!
Thanks!
Torsten
MVP
Tagged:
Answers
I notified the developers about this and they've agreed it's a bug!
They have this issue added onto their backlog to take review, I'll keep you posted on any updates!
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?
I got an update from the developers and the issue with the Microsoft SQL Parser we use for certain parts of SQL Prompt. Unfortunately, there is very little we can do here, we have actually raised an issue with Microsoft in relation to RECOMPILE in certain statements however we haven't had a response on it.
Until Microsoft implements a fix on their side, we're a little stuck on this.
Sorry!
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?