declare @inputStr xml
set @inputStr='
ab
aabb
'
SELECT @input.value('(/Request/a)[1]','varchar(100)')
取到a
SELECT @input.value('(/Request/a)[2]','varchar(100)')
取到aa
那么下标1或者2 这里能否使用变量呢?
比如说循环取
http://www.jb51.net/article/86194.htm
http://www.cnblogs.com/fuhongwei041/archive/2010/09/04/1818213.html