Re: Q re CTE - simple (I think)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Tue, 18 Aug 2009 18:03:58 -0700 (PDT), --CELKO-- wrote:

I type || for concatenation without thinking about it since it is ANSI/
ISO Standard and assume that people can read it. And I hope that MS
will catch up, since it makes the compiler a little easier to write.
SQL Server is still decades behind other products im so many ways.

Hi Joe,

And do you also routinely type the left- and right-pointing single
quotes (? and ?) instead of the ANSI standard apostroph (')? Or were you
actually just coming from a MySQL gig and now making up excuses instead
of just admitting that you had forgotten to adjust your mindset to a
different product before switching newsgroup?

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
.

Relevant Pages

  • Re: pre .net
    ... any of the Microsoft libraries, how would talk to SQL Server then? ... ODBC is portable, specified in an ISO standard. ...
    (microsoft.public.vc.language)
  • Re: week numbers
    ... The bigger problem is that SQL Server doesn't use the same rules as we generally use (ISO standard, ... Sweden etc) for week numbering. ... According to SQL Server, Jan 1 is always week 1. ...
    (microsoft.public.sqlserver.server)
  • Re: Q re CTE - simple (I think)
    ... I type || for concatenation without thinking about it since it is ANSI/ ... ISO Standard and assume that people can read it. ... since it makes the compiler a little easier to write. ... SQL Server is still decades behind other products im so many ways. ...
    (microsoft.public.sqlserver.programming)
  • Re: good c compiler
    ... for each of the integer types char, short, int, long and long ... FYI gcc is NOT the ISO standard for the C language. ... What use is a compiler ... that doesn't follow the ABI for its target platform? ...
    (comp.lang.c)
  • RE: Wanted: Discussion on MSSQL Internals Interview Qustions
    ... Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005 ... What is the relationship between the query optimizer and the TSQL ... T-SQL compiler? ... Does the compiled TSQL code contain the query optimizations ...
    (microsoft.public.sqlserver.programming)