Plug in to sql server 2k

摘要

One of XML's dirty little secrets is that it's not always the right solution for every problem. Case in point: I was recently instructing a group of students in methods for converting database data into XML. One scenario calls for retrieving data through an ODBC connection, and marking up the results with XML. Once the data is in XML form, you can choose to apply a transformation to the result set, or stream the markup (the XML data) directly to your client application. After going through this process, the response I often get is, "That's great, but what's the benefit of doing it this way?" The fact is, database developers can already stream data to clients quite nicely.