SQL Prompt doesn't format OFFSET

Provides intelligent code completion for SQL Server editors.

Moderators: Anu Deshpande, Aaron Law, David Priddle

SQL Prompt doesn't format OFFSET

Postby nhaslam » Thu Nov 07, 2013 9:15 pm

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
 
Posts: 1
Joined: Thu Nov 07, 2013 9:10 pm
Location: United Kingdom

Postby Anu Deshpande » Fri Nov 08, 2013 11:56 am

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
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Prompt 6

Who is online

Users browsing this forum: No registered users and 0 guests