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

SQL Window functions cause error when formatting code

a_ted_wa_ted_w Posts: 5 Bronze 1
edited May 24, 2016 11:17AM in SQL Prompt
for example:
SELECT @LibraryID
, c.CategoryNameLTID
, ROW_NUMBER() OVER (ORDER BY ID) AS Row
, @UserID
, @DateTime
FROM BestPracticeLibrary.Categories AS c;

perfectly valid SQL, but SQL Prompt does not like it.

Comments

Sign In or Register to comment.