日期:2014-05-16 浏览次数:20451 次
exec sp_executesql N'SELECT *编辑得过,查不出结果
FROM VWorkFlowNodes
WHERE (NodeSerils in(@1))',N'@1 nvarchar(4000)',
@1=N'2,5'
exec sp_executesql N'SELECT *正常查询
FROM VWorkFlowNodes
WHERE (NodeSerils in(2,5))'
exec sp_executesql N'SELECT *正常查询
FROM VWorkFlowNodes
WHERE (NodeSerils in(@1))',N'@1 nvarchar(4000)',
@1=N'2'
SELECT * FROM VWorkFlowNodes WHERE charindex(','+NodeSerils+',',',2,5,')>0这样呢?有结果不?