Bug - with Recompile

torsten.strauss

Hi Redgate Team

SQLPrompt cannot format the following code.

DECLARE @StatementAllTransactions nvarchar(4000)

DECLARE @ParameterDefintionAllTransactions nvarchar(4000)

DECLARE @_ParentAuthorityId int

INSERT dbo.mTransactions

(

OPUCode

)

EXECUTE sp_executesql

@StatementAllTransactions

, @ParameterDefintionAllTransactions

, @_ParentAuthorityId = 1

WITH RECOMPILE;

Would be great to see a fix in the next release!

Thanks!

Torsten
MVP

DanC

Hi @torsten.strauss

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!

DanC

Hi @torsten.strauss

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!