大家好,又见面了,我是你们的朋友全栈君。
declare @s varchar(100) set @s='1,2,3' --法一: select * from tb where charindex(','+ltrim(id)+',',','+@s+',')>0 --法二: exec('select * from tb where id in ('+@s+')')
转载于:https://www.cnblogs.com/zhaozhengyan/p/SQL_Where_Splite.html
发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/151265.html原文链接:https://javaforall.net