如何在SQL Server 2000中执行XML PATH查询 [英] how to do XML PATH query in sql server 2000

问题描述

我有一个问题，是SQL2000支持的FOR XML PATH关键字.
如果是，
我收到诸如关键字"For"附近的语法不正确"之类的错误.
如果没有，
请举例说明如何实现或编写与FOR XML PATH等效的查询.

Hi,

I have a question that Is FOR XML PATH keyword supporetd by SQL2000.
If Yes,
i''ve getting error like "Incorrect syntax near the keyword ''For''".
if No,
kindly tell me with an example how to implement or write query equavalent to FOR XML PATH.

推荐答案

SQL 2000不支持FOR XML PATH
检查这是否有帮助

FOR XML PATH is not supported by sql 2000
check if this is helpfull

select * from <tablename> FOR XML AUTO, ELEMENTS</tablename>

请参考
http://msdn.microsoft.com/en-us/magazine/cc163782.aspx [ ^ ]
http://msdn.microsoft.com/en-us/library/aa226519 (v = sql.80).aspx [ http://www.mssqltips.com/sqlservertip/1077/returning -xml-result-sets-with-sql-server/ [

refer this
http://msdn.microsoft.com/en-us/magazine/cc163782.aspx[^]
http://msdn.microsoft.com/en-us/library/aa226519(v=sql.80).aspx[^]
http://www.mssqltips.com/sqlservertip/1077/returning-xml-result-sets-with-sql-server/[^]

这篇关于如何在SQL Server 2000中执行XML PATH查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！