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

Bug in formatting when transaction level is uncommitted

SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED


;WITH roots AS
(
  SELECT
    1 AS one

)
SELECT * FROM roots r
order by 1

Following code is formatted like:
SET NOCOUNT ON;
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;WITH roots
                                                 AS (SELECT 1 AS one)
SELECT *
FROM roots r
ORDER BY 1;
sdks
0

Comments

3 comments

Sort by
  • David Priddle
    Hi sdks,

    Unfortunately I'm unable to reproduce this here. Would you be able to send your style over to us at sqlpromptteam@red-gate.com?

    You can find the style by looking in the folder referenced at the top of the formatting styles window:

    004ssZm.png

    Best regards,

    David
    David Priddle
    0
  • sdks
    Hi David,
    after downloading the latest beta version, this problem dissappeared.
    sdks
    0
  • David Priddle
    Hi sdks,

    Glad to hear it!

    Best regards,

    David
    David Priddle
    0

Add comment

Please sign in to leave a comment.