摘要： Sqlserver in 实现 参数化查询 XML类型解决方案 [转]1：如果参数是int类型： declare @a xml set @a=' 1 5 4 3 2' 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=' a b5 c4 d3 e2' select * from product 阅读全文