Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Poll Discussion
 Poll: Do you use SQL Server's XML features?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-17 : 22:20:06
This thread goes with the poll Do you use SQL Server's XML features?.

dsdeming

479 Posts

Posted - 2002-03-19 : 08:01:02
Yes, we use XML, but not as heavily as I would like. I deal with large batches of hierarchical data every day, and XML provides an elegant mechanism for transferring that data between various systems. I haven't performed thorough performance testing of XML versus older methods, but unless the performance hit is significant, I'll keep using XML.

Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-03-19 : 21:17:52
I have been doing some fun things with it. Using FOR XML EXPLICIT to format hierarchical recordsets, then bringing them into an ASP page using ADO, then dumping it straight out with an XSL sheet.

Zero presentation code in the ASP page, it is kinda cool. But XSL can be a bitch when you want to do something complex with it.

Damian
Go to Top of Page
   

- Advertisement -