select lineInfo.value('(CallTrace/Node[3]/@ID)[1]','varchar(50)') from SalesLine_xml 请问如何把Node[3]将3用参数变量i代替如下
declare @i int
set @i=2
select lineInfo.value('(CallTrace/Node[@i]/@ID)[1]','varchar(50)') from SalesLine_xml
declare @i int
set @i=2
select lineInfo.value('(CallTrace/Node[@i]/@ID)[1]','varchar(50)') from SalesLine_xml
declare @i int
set @i=2
select lineInfo.value('(CallTrace/Node['+rtrim(@i)+']/@ID)[1]','varchar(50)') from SalesLine_xml
xml 数据类型方法 "value" 的参数 1 必须是字符串文字。