top | item 45077204 (no title) jslaby | 6 months ago Of course, trying out the first example doesn't work on SQL Server.. discuss order hn newest datadrivenangel|6 months ago "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. jslaby|6 months ago 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
datadrivenangel|6 months ago "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. jslaby|6 months ago 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
jslaby|6 months ago 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
datadrivenangel|6 months ago
Footnote on page 3.
jslaby|6 months ago