What are the challenges you face when working across database platforms? Take the survey
Options

Bug in formatting when transaction level is uncommitted

sdkssdks Posts: 44 Bronze 2
edited December 2, 2016 5:00AM in SQL Prompt
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;

Comments

Sign In or Register to comment.