Comment on SQL Design Patterns (2010)Comments−jslaby1yOf course, trying out the first example doesn't work on SQL Server..−datadrivenangel1y"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.−jslaby1yT-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
Comments
Of course, trying out the first example doesn't work on SQL Server..
"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.
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