Re: Non ANSI Transact-SQL statements

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/29/04


Date: Mon, 29 Mar 2004 10:39:39 +0200

However, there are a lot of non ANSI SQL statements for witch the FIPS_FLAGGER doesn't warn, as it should.
Mimer (www.mimer.se) has a SQL validator on the web (and also as a web service!). Also, SQL Reskit (I believe
it is) comes with a word doc which shots the BNF (grammar) for the TSQL language and colour coding shows
whether a statement is ANSI SQL compliant or not.

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Adam Machanic" <amachanic@air-worldwide.nospamallowed.com> wrote in message
news:%235GuRo2EEHA.4016@TK2MSFTNGP09.phx.gbl...
> Check out SET FIPS_FLAGGER in BOL ...
>
>
> "Marc" <anonymous@discussions.microsoft.com> wrote in message
> news:4B1C6A92-2524-4697-AD71-816326DF58B2@microsoft.com...
> > Do you know what Transact-SQL statements are not ANSI compliant?
>
>


Relevant Pages

  • Re: Invalid cursor state
    ... It is correct that the ANSI SQL standard parts from the relational model ... regarding column ordering. ... every row of a table is a value of the i-th column of that table. ...
    (microsoft.public.sqlserver.programming)
  • Problem converting table self reference from TransactSQL to ANSI SQL
    ... I have a Transact SQL query that I'm trying to re-cast as an equivalent ... ANSI SQL query and so far I have not been able to formulate it so it ...
    (comp.databases.sybase)
  • RE: OLEDBDataReader has no rows, yet query is fine in Access
    ... the Jet SQL statement but ADO.NET just can recognize the ANSI SQL statement. ... I suggest you watch "Comparison of Microsoft Jet SQL and ANSI SQL" article ...
    (microsoft.public.data.ado)
  • Re: Differences between TSQL and SQL-92
    ... Which level of ANSI SQL -92? ... SQL Server supports the entry level, ... In SQL Server resource kit, there's a big word doc which points ...
    (microsoft.public.sqlserver.programming)
  • Re: Error in sample Northwind?
    ... The ANSI SQL compliant way is to enclose the name inside double-quotes. ... Tibor Karaszi, SQL Server MVP ... Northwind database in SQL 2000 it is shown as Order Details. ...
    (microsoft.public.sqlserver.server)