Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Stairway to SQL Dialects Level 1: Overview Expand / Collapse
Author
Message
Posted Thursday, May 10, 2012 8:43 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, July 20, 2014 11:55 AM
Points: 1,945, Visits: 2,860
Comments posted to this topic are about the item Stairway to SQL Dialects Level 1: Overview

Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
Post #1297933
Posted Thursday, May 10, 2012 9:13 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 3:58 PM
Points: 1,297, Visits: 1,657
Good article. One point, though:
To use another Transact SQL example, CONVERT() with non-temporal data types can be changed to CAST(). But CONVERT() is an overloaded function that has an optional third parameter when it casts temporal data to display strings.


The third CONVERT() parameter is not limited to temporal data. It can also be used to change the way numeric data are converted to strings. Ignoring that when porting numeric conversions could break your code.
Post #1297957
Posted Wednesday, October 31, 2012 5:57 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:07 AM
Points: 1,060, Visits: 876
Great, informative and interesting, thanks very much.

But...

and keep release n+1 code running on release n software.


Perhaps I am not warmed up yet, but shouldn't that read n-1?



Post #1379264
Posted Wednesday, October 31, 2012 10:59 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 9:05 PM
Points: 256, Visits: 2,004
Joe, thanks. Interesting article and good incentive to improve my coding.

Elliott
Post #1379446
Posted Wednesday, October 31, 2012 12:23 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, July 25, 2014 7:21 AM
Points: 524, Visits: 800
Your real worry is Cowboy Coder Tony, who writes proprietary code. His dialect is so strong he codes like a hillbilly. He might do this to ensure job security; the more obscure his code, the safer he feels.


So true! Sad, but true.


Hakim Ali
www.sqlzen.com
Post #1379482
Posted Thursday, November 15, 2012 8:10 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 9:00 AM
Points: 1,595, Visits: 4,585
This is not an issue SQL language syntax, but as you're writing this series, it may be worth mentioning that the value NULL functions differently across RDMS platforms. For example, Oracle treats '' (a character value with zero length) as equivalent to NULL, which is not the case for SQL Server (and does this conform to the ANSI NULL standard?). Thus when porting SQL between platforms, the same SQL using the same dataset can produce a different resultset.
Post #1385184
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse