MS SQL] 변수로 넘긴 값을 이용한 SQL : where columName in (123,1231,32132)

@cartUid = '42254,42255,'

declare @convertCartUid table (

cartUid bigint

)

while charindex(',', @cartUid) <> 0

begin

insert into @convertCartUid values(substring(@cartUid, 1, charindex(',', @cartUid)-1))

set @cartUid = substring(@cartUid, charindex(',', @cartUid)+1, len(@cartUid)) 

end