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

SQL Prompt doesn't format OFFSET

Hi,
When formatting this (AdventureWorks2012) code:

SELECT ROW_NUMBER() OVER ( ORDER BY Name ) AS 'RowNumber', name, listprice
FROM Production.Product
ORDER BY Name
OFFSET 20 ROWS
FETCH NEXT 10 ROWS only

It formats it too
SELECT ROW_NUMBER() OVER ( ORDER BY Name ) AS 'RowNumber', name, listprice
FROM Production.Product
ORDER BY NameOFFSET 20 ROWS
FETCH NEXT 10 ROWS only

which is invalid (NameOFFSET should maintain the space)

This is on SQL Prompt 6.1.0.88.

Cheers

Nick
nhaslam
0

Comments

1 comment

Sort by
  • Anu D
    Many thanks for your post.

    Can you email us the SQL Prompt style you are using?

    You can export your style as specified here

    Please email this to support@red-gate.com with this forum link in it's subject.
    Anu D
    0

Add comment

Please sign in to leave a comment.