where in 的问题请教

Question

exec('select * from MyTable where Id in('+@ForeceId+')')

Answer 1

Declare @ForeceId sql_variant
SET @ForeceId='37,38'exec('Select * from MyTable
       where Id in('+@ForeceId)

Answer 2

exec('select * from MyTable where Id in('+@ForeceId+')')

Answer 3

Declare @ForeceId sql_variant
SET @ForeceId='37,38'select * from MyTable where charindex(','+cast(id as varchar)+',',','+cast(@ForeceId as varchar)+',')>0

Answer 4

Declare @ForeceId sql_variant
SET @ForeceId='37,38'
select * from MyTable
where charindex(id,@ForeceId)>0