sqlxml.org topic

Friday, November 20, 2009

Retrieving XML

[029] - Is there a way to export XML from SQL using a stored procedure?

[010] - How can I extract XML from SQL using DTS?

[054] - How To: Use an output parameter with a stored procedure

[002] - How can I retrieve the results of a FOR XML query using ASP?

[048] - HOW TO: Use XML templates to edit/view data using HTML forms.

[102] - How To: Shape FOR XML AUTO results using SQL views

[042] - How can I parse XML from a text column using sp_xml_preparedocument?

[104] - HOW TO: Get the XML text of a FOR XML query within SQL.

[001] - How can I retrieve the results of a FOR XML query using VB?

[055] - How To: Creating parent/child relationships in XML using XSL

[087] - Tutorial: Using SQLXML Templates with ASP.Net

[028] - How can I get my FOR XML EXPLICIT query to work?

[053] - How To: Creating parent/child relationships in XML

[072] - Tutorial: Extending SQLXML with XSL and Objects

[016] - How do I get a root element with my FOR XML query?

[040] - How To: Get return value from a stored procedure.

[037] - HOW TO: Paging result set returned via XML

[059] - How can I get NULL values to show up in my XML using schemas?

[058] - HOW TO: Use parameters with ADO Streams and SQLXML

[099] - How To: Combine FOR XML AUTO queries using XSL

[086] - How can return XML from a stored procedure using VB?

[014] - How do I get NULL values to show up in my XML?

[015] - How can I get HTML data from my database into a webpage using FOR XML?

[046] - How can I put XML values into attributes using XSL?

[047] - HOW TO: Extend the functionality of XSL with scripting.

[070] - Can I store my XSL in a stored procedure?

[088] - How can I create recursive XML?

[011] - How can I format dates with FOR XML?

[095] - How can I use aggregates and the group by clause with FOR XML?

[096] - Why do I get a compilation error when importing the Microsoft.Data.SqlXml namespace?

[032] - Tutorial: How to create an XML data island using JScript.

[025] - Why do I get an error when using Cmd.Properties("Output Stream")?

[093] - How To: Passing NTLM credentials when using ServerXMLHTTP.

[068] - Should I use XSD schemas or for XML explicit to export my XML?

[052] - How To: Retrieving binary data using XML

[089] - How can I get an element with a CDATA section?

[076] - Why can't I get valid XML from SQL Server?

[003] - Can SQL 7 be set up to use the FOR XML... commands?

[022] - Why are the results of my FOR XML EXPLICIT query not grouped properly?

[062] - How can I use client side XML with a stored procedure and ADO?

[075] - How To: Create multiple element types in a schema based on a filter

[065] - How can I include an XML file in my template?

[069] - Why are the elements returned from my XSD schema not grouped properly?

[085] - Why do I get a "queries not allowed" error?

[080] - How can I return XML without the sql namespace declaration?

[057] - INFO: Using FOR XML AUTO with client side XML

[081] - How To: Union all with different data types using explicit

[021] - How can I execute a stored procedure using ADO streams?

[035] - When should I use the CommandStream vs. the CommandText property?

[017] - How can I pass a list of values to be used in a IN query?

[083] - How can I prevent special characters from being encoded?

[026] - How can I hide SQL errors in XML from users instead of returning them?

[045] - How can I detect MSSQLErrors when my XML is in a DOM object?


© 2001, 2002, 2003 sqlxml.org