4 ms·
[strikeout, see comment above, it's in SQL99] MSSQL has a similar construct with Common Table Expressions (CTE's) though, so it' not unique to PG.
by bigdubs 13y ago
[strikeout, see comment above, it's in SQL99]
MSSQL has a similar construct with Common Table Expressions (CTE's) though, so it' not unique to PG.
- rachbelaid 13y agoThanks for the details.
- NDizzle 13y agoAnother tip for using WITH on MSSQL - prefix it with semicolon like this: ;WITH MSSQL makes it so that people pick up bad habits over the years and often you'll find missing semicolons at the end of statements. While the parser will intelligently handle missing semicolons for the majority of of scripts, it will bomb 100% of the time (at least up to 2008R2) on WITH.