Re: Differences between TSQL and SQL-92

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 02/25/05


Date: Fri, 25 Feb 2005 21:44:36 +0100

Bunch of things. Which level of ANSI SQL -92? SQL Server supports the entry level, but it also has a
load of stuff outside ANSI SQL 92. In SQL Server resource kit, there's a big word doc which points
out whether each TSQL command adheres to ANSI SQL-92. Also, you can try the SQL validator at
www.mimer.com.

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
<craigkenisston@hotmail.com> wrote in message 
news:1109363354.285681.136860@f14g2000cwb.googlegroups.com...
> Hi,
>
> I guess there should be some differences between SQL Server's dialect
> TSQL and strictily the SQL-92 standard.
>
> For a researcg work I'm doing I need to collect and study this
> difference, I've not found big things so far more than a few difference
> in functions, unless my BNF lecture is failing.
>
> Does anybody know an existing article that already put TSQL and SQL-92
> face to face ?
>
> Is there any big noticeable difference that you can cite here in this
> newsgroup ?
>
>
> Thanks in advance,
> 


Relevant Pages

  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)
  • Re: WSS 3.0 question
    ... I followed the advise given in removing WSS 3.0 etc, ... the server is complaining that the SQL service(?) was tempered with or corrupt. ... I may just instal the SQL server as I was going eventuall use it anyway. ... If WSUS 3.0 is installed, I would suggest you uninstall it and then you install WSS 3.0. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... I did test and it did not install the client tools. ... http://www.clusterhelp.com - Cluster Training ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
    (microsoft.public.sqlserver.clustering)
  • Re: WSUS
    ... I'm not seeing performance issues with the full enchilada installed, and 25 users busy hitting SQL. ... WSUS isn't difficult to uninstall - if you have WSUS v2 (installed with SBS R2) uninstall R2 from add/remove programs. ... How can anyone work with 4 instances of SQL Server on the same box? ...
    (microsoft.public.windows.server.sbs)
  • Re: Cannot setup SQL Mail on SBS 2003
    ... Microsoft CSS Online Newsgroup Support ... Cannot setup SQL Mail on SBS 2003 ... The account you use to start the SQL Server service must be a domain ...
    (microsoft.public.windows.server.sbs)