Oracle does this too and did it before M$ SQL 2000 came about! (NO
FLAME WAR INTENDED OR NEEDED!)
A question, my boss claims that M$ SQL 2000 is actually based on XML,
as in the storage structure and such. I've argued that this is not
so, that it will return your queries as XML but that the actual on
disk structure, if you will, is probably the same as SQL Server 7.
What is the truth here?
DKnudsen
From: [EMAIL PROTECTED] AT INTERNET on 02/09/2001 07:29 AM
To: Douglas Knudsen/ATL/ALLTELCORP, [EMAIL PROTECTED] AT
INTERNET@CCMAIL
cc:
Subject: Re: SQL 2000
The coolest 2K extra is direct XML support. You can perform a http:
query
directly to the db and have XML returned or transformed XML via XSL
into ...
HTML or whatever.
http://yourdomain/SQLRoot?sql=SELECT+*+FROM+products+FOR+XML+AUTO&root
=root
Also, I really like the upgrade to query analyzer.
Bill Reichard
Willow Gold
In a message dated 2/8/01 7:33:46 PM Eastern Standard Time,
[EMAIL PROTECTED] writes:
> My recollection of the insight of some SQL Professionals is the
SQL2000 is
> mostly an upgrade for large enterprise users (the Oracle wars).
>
> best, paul
>
> At 02:44 PM 2/7/01 -0600, you wrote:
> >what features does it have that SQL 7 doesn't? Bug fixes maybe? I
mean,
> is
> >it worth upgrading to considering how much it costs?
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
