declare rundetCursor cursor
for
select distinct deptcode from table where deptcode in(@code)
.....先前发过一个贴子,就是当@code='01'时正确,当@code='01'+','+'02'时无结果,其他地方可以通过EXEC('select distinct deptcode from table where deptcode in('+@code+')')来解决,但是这里好象行不通,怎么处理??
for
select distinct deptcode from table where deptcode in(@code)
.....先前发过一个贴子,就是当@code='01'时正确,当@code='01'+','+'02'时无结果,其他地方可以通过EXEC('select distinct deptcode from table where deptcode in('+@code+')')来解决,但是这里好象行不通,怎么处理??
from table
where CHARINDEX(','+deptcode+',', ','+@code+',')>0