Non ANSI Transact-SQL statements

Do you know what Transact-SQL statements are not ANSI compliant?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?|||However, there are a lot of non ANSI SQL statements for witch the FIPS_FLAGG
ER doesn't warn, as it should.
Mimer (www.mimer.se) has a SQL validator on the web (and also as a web servi
ce!). Also, SQL Reskit (I believe
it is) comes with a word doc which shots the BNF (grammar) for the TSQL lang
uage 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...
>|||Thanks for the clarification, Tibor. I'll check those out links out.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:euXuflWFEHA.3456@.tk2msftngp13.phx.gbl...
> 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...
>