Issues with NOLOCK hint
asentell
Posts: 42
We use the NOLOCK hint extensively, and it seems that SQL Refactor doesn't quite know what to make of it ... or at least I don't know how to tell SQL Refactor what I want it to do. Here's the code before:
SELECT i.*
FROM sys.objects o WITH (NOLOCK) JOIN
sys.indexes i WITH (NOLOCK) ON o.[object_id] = i.[object_id]
And here's the code after:
SELECT
i.*
FROM
sys.objects o WITH (NOLOCK)
JOIN sys.indexes i WITH (NOLOCK)
ON o.[object_id] = i.[object_id]
It's not possible to tell in this proportional font, but the blue "ON" line begins way out underneath the open parenthesis of the nolock hint when I want it to be indented just like every other indentation, 4 spaces.
Thanks,
Aaron
SELECT i.*
FROM sys.objects o WITH (NOLOCK) JOIN
sys.indexes i WITH (NOLOCK) ON o.[object_id] = i.[object_id]
And here's the code after:
SELECT
i.*
FROM
sys.objects o WITH (NOLOCK)
JOIN sys.indexes i WITH (NOLOCK)
ON o.[object_id] = i.[object_id]
It's not possible to tell in this proportional font, but the blue "ON" line begins way out underneath the open parenthesis of the nolock hint when I want it to be indented just like every other indentation, 4 spaces.
Thanks,
Aaron
