Declare @ForeceId sql_variant
SET @ForeceId='37,38'
select * from MyTable
where Id in(@ForeceId)
这样得不出结果,但写成这样就可以:
select * from MyTable
where Id in(37,38)
@ForeceId要动态传入的,请问该怎实现呢,谢谢
...全文
916打赏收藏
where in 的问题请教
Declare @ForeceId sql_variant SET @ForeceId='37,38' select * from MyTable where Id in(@ForeceId) 这样得不出结果,但写成这样就可以: select * from MyTable where Id in(37,38) @ForeceId要动态传入的,请问该怎实现呢,谢谢