Bug in formatting when transaction level is uncommitted

sdks

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;

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:



Best regards,

David

sdks

Hi David,
after downloading the latest beta version, this problem dissappeared.

David Priddle

Hi sdks,

Glad to hear it!

Best regards,

David