InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 13:44:38 GMT20http://www.sqlservercentral.com/Forums/Topic1297933-1604-1.aspxThis 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.Thu, 15 Nov 2012 08:10:41 GMTEric M Russellhttp://www.sqlservercentral.com/Forums/Topic1297933-1604-1.aspx[quote]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.[/quote]So true! Sad, but true.Wed, 31 Oct 2012 12:23:48 GMThakim.alihttp://www.sqlservercentral.com/Forums/Topic1297933-1604-1.aspxJoe, thanks. Interesting article and good incentive to improve my coding.ElliottWed, 31 Oct 2012 10:59:49 GMTElliott Berkihiserhttp://www.sqlservercentral.com/Forums/Topic1297933-1604-1.aspxGreat, informative and interesting, thanks very much.But...[quote] and keep release n+1 code running on release n software.[/quote]Perhaps I am not warmed up yet, but shouldn't that read n-1?Wed, 31 Oct 2012 05:57:02 GMTRichBhttp://www.sqlservercentral.com/Forums/Topic1297933-1604-1.aspxGood article. One point, though:[quote]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. [/quote]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.Thu, 10 May 2012 09:13:30 GMTsknoxhttp://www.sqlservercentral.com/Forums/Topic1297933-1604-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Stairway+Series/90579/">Stairway to SQL Dialects Level 1: Overview</A>[/B]Thu, 10 May 2012 08:43:41 GMTCELKO