存储过程查询XML

[已解决问题] 解决于 2008-01-24 09:53

alter procedure prc_test (  @ID nvarchar(50) ) as DECLARE @tmpXML AS XML SET @tmpXML = ' <Categories>     <CategoryInfo CategoryID ="1">         <CategoryName>Beverages</CategoryName>         <Description>Soft drinks, coffees, teas, beers, and ales</Description>     </CategoryInfo>     <CategoryInfo CategoryID ="2">         <CategoryName>Condiments</CategoryName>         <Description>Sweet and savory sauces, relishes, spreads, and seasonings</Description>     </CategoryInfo>     <CategoryInfo CategoryID ="3">         <CategoryName>Confections</CategoryName>         <Description>Desserts, candies, and sweet breads</Description>     </CategoryInfo>     <CategoryInfo CategoryID ="4">         <CategoryName>Dairy Products</CategoryName>         <Description>Cheeses</Description>     </CategoryInfo> </Categories> ' SELECT @tmpXML.query(' for $var in /Categories/CategoryInfo where $var <A>/@CategoryID</A> ="<A href="mailto:'+@ID+'">'+@ID+'</A>" return ($var)') AS test GO --exec prc_test 2 我要按参数@ID查询 @CategoryID，这里应该怎么写？ where $var <A>/@CategoryID</A> ="<A href="mailto:'+@ID+'">'+@ID+'</A>"

数据库 SQL Server

liaozhengcheng | 初学一级 | 园豆：100
提问于：2007-12-26 14:08

< >

最佳答案

SELECT @tmpXML.query(' for $var in /Categories/CategoryInfo where $var /@CategoryID =sql:variable("@ID") return ($var)') AS test 还有疑问的话参考以下文章： http://msdn2.microsoft.com/zh-cn/library/ms345117.aspx

四眼蒙面侠 | 小虾三级 |园豆：504 | 2007-12-29 13:42

清除回答草稿

您需要登录以后才能回答，未注册用户请先注册。

欢迎，请先 登录 或者 注册 。

存储过程查询XML

欢迎，请先登录或者注册。