Posts
Sort by recent activity
SQL Window functions cause error when formatting code
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 ...