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+')')来解决,但是这里好象行不通,怎么处理??
...全文
837打赏收藏
在线寻求存储过程的问题~~~~~~~~~~
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+')')来解决,但是这里好象行不通,怎么处理??