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

SQL Prompt doesn't format OFFSET

nhaslamnhaslam Posts: 2
edited November 8, 2013 5:56AM in SQL Prompt
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

Comments

  • Options
    Anu DAnu D Posts: 876 Silver 3
    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.