←back to thread

SQL Design Patterns (2010)

(vadimtropashko.wordpress.com)
149 points mci | 2 comments | 27 Aug 25 04:59 UTC | HN request time: 0.464s | source
Show context
jslaby ◴[30 Aug 25 19:13 UTC] No.45077204[source]▶
Of course, trying out the first example doesn't work on SQL Server..
replies(1): >>45077229 #
1. datadrivenangel ◴[30 Aug 25 19:17 UTC] No.45077229[source]▶
"We use Oracle syntax and write <column expr> <alias> instead of ANSI SQL <column expr> AS <alias>. Ditto for table expressions"

Footnote on page 3.

replies(1): >>45077468 #
2. jslaby ◴[30 Aug 25 19:46 UTC] No.45077468[source]▶
T-SQL can handle that alias expr just fine, but the seqNum returned is 4,8,12,16,20 instead of the 1,2,3... I tried on MySQL and it works fine. I'm not sure how SQL Server is handling those cartesian joins differently