SQL Server如何使用XML格式传输解析

Sqlserver in 实现 参数化查询 XML类型解决方案 [转]

1：如果参数是int类型： 
declare @a xml 
set @a=' 
<row><id>1</id></row> 
<row><id>5</id></row> 
<row><id>4</id></row> 
<row><id>3</id></row> 
<row><id>2</id></row>' 
select * from product where id in ( 
select d.x.value('./id[1]','int') from @a.nodes('/*') as d(x))
2：如果参数是varchar类型：
declare @a xml 
set @a=' 
<row><name>a</name></row> 
<row><name>b5</name></row> 
<row><name>c4</name></row> 
<row><name>d3</name></row> 
<row><name>e2</name></row>' 
select * from product where pname in ( 
select d.x.value('./name[1]','varchar(100)') from @a.nodes('/*') as d(x))

 

转载于:https://www.cnblogs.com/lidingwen/p/3154383.html