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/[^]