How can we help you today? How can we help you today?

Bug - with Recompile

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
torsten.strauss
0

Comments

2 comments

Sort by
  • 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
    0
  • 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!
    DanC
    0

Add comment

Please sign in to leave a comment.