interviews.dotnetthread.com

↑ Grab this Headline Animator

Wednesday, July 9, 2008

How do SQL server 2000 and XML linked? Can XML be used to access data?FOR XML (ROW, AUTO, EXPLICIT)

You can execute SQL queries against existing relational databases to return results as XML rather than
standard rowsets. These queries can be executed directly or from within stored procedures. To retrieve
XML results, use the FOR XML clause of the SELECT statement and specify an XML mode of RAW, AUTO,
or EXPLICIT.

Submit this story to DotNetKicks

No comments:

Post a Comment

Post your comments/questions/feedback for this Article.

 

Latest Articles