November 15, 2002 at 3:23 pm
Hi,
Have you guys used XML between IIS and SQL? We have an IIS box that receives XML format data from external sources and insert it into SQL. The developers aren't interested in SQL built-in XML; saying it is easier in ASP. If this is true then is there any improvement in Yukon?
Thx.
November 18, 2002 at 8:00 am
This was removed by the editor as SPAM
November 18, 2002 at 8:52 am
There will undoubtedly be improvements in Yukon.
I don't use IIS and SQL but do use FOR XML and OPENXML
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
November 18, 2002 at 3:57 pm
OpenXML is a winner, lets you handle cases where you need what is basically a delimited string. We've use for xml in a few cases. Overall our use of XML via SQL has been low and in most cases badly applied. I question the wisdom at this point of using XML on the db server, might get better in Yukon. Updategrams, etc, may be useful if you're getting native XML in via whatever interface. I'd say look at what they are doing and if you can do it better (which equals either faster or less work for them) then show them. Otherwise just wait it out:-)
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply