select in 有关问题

求助：select in 问题
我现在有一个字符串@tem=‘11，12，13’
我现在要用select * from table where columnName in(@tem)操作，注意column是int类型的这改怎么处理？

[解决办法]
exec('select * from table where columnName in(' + cast(@tem as varchar) + ')')
[解决办法]

SQL code

exec('select * from table where columnName in('+@tem+')')
[解决办法]
探讨

exec('select * from table where columnName in(' + cast(@tem as varchar) + ')')

[解决办法]
SQL code
exec('select * from table where columnName in('+@tem+')')
[解决办法]
SQL code
declare @tem as varchar(20)set @tem = '11,12,13' print('select * from table where columnName in (' + cast(@tem as varchar) + ')')/*select * from table where columnName in (11,12,13)*/exec('select * from table where columnName in (' + cast(@tem as varchar) + ')')