Re: Two questions, standard sql statement

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

David Thielen (thielen@xxxxxxxxxxxxx) writes:
You would think by now they would have these as part of the standard
SQL. Oh well, we're left still having to write our own code for each
vendor...

There Standard SQL, and there is Standard SQL. That is, there is an
ANSI standard which is updated every now and then. Then there is
what is actually is implemented everywhere and works everywhere. There
is a huge difference between the two.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: user wants access
    ... I would strongly recommend you read Books Online for this information. ... the db_securityadmin fixed database role. ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.server)
  • Re: reclaiming LOB space
    ... Books Online says "Reclaims space from dropped variable-length ... But as I understood Mike, he did not drop the column, only setting the ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.server)
  • Re: Duplicate Values Question
    ... cannot handle VBA let alone work with SQL Management Studio (BRING BACK ... I have high hopes for Jet now that the Access team ... has taken over development from the SQL Server team. ... and Jet has been left far behind as regards Standard SQL. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Welcher Provider?
    ... Ich verwende immer den Standard SQL Server Treiber, ... Vermutlich ist das inzwischen nicht mehr so und gefixt, aber ich habe bisher mit dem Standard SQL Server Treiber nie schlechte Erfahrungen gemacht. ...
    (microsoft.public.de.access)
  • Re: Wanted: algorithm for a kind of "between" query
    ... Here are the rules for row comparisons in Standard SQL taken from SQL ... Standard SQL generalized the theta operators so they would work on row ... (TRUE AND UNKNOWN AND TRUE AND FALSE); ...
    (comp.databases)