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
