Activity overview
Latest activity by nhaslam
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 ROW...