适用于SQLSERVE 2012版本跟老版本,新版2016可以用string_spl等
如果一个参数为多个数据时:
DECLARE @TMID varchar(max)
set @TMID= '0962338,0962339'
如何解决呢,用到了字符串拆分
DECLARE @TMID varchar(max)
set @TMID= '0962338,0962339'
SELECT Split.a.value('.', 'NVARCHAR(MAX)') DATA
FROM(
SELECT CAST('<X>'+REPLACE(@TMID, ',', '</X><X>')+'</X>' AS XML) AS String
) AS A CROSS APPLY String.nodes('/X') AS Split(a)