@picclassids 以,分隔的字符串变量如"1,2,3"
piclassids 存储以,分隔的字符串字段,如"3,4,5"
以下sql判断picclassids字段中是否存在@picclassids中的任何一个值
select * from t_pic where exists(select * from fn_split(picclassids,',') where a in (select * from fn_split(@picclassids,',')))
@picclassids 以,分隔的字符串变量如"1,2,3"
piclassids 存储以,分隔的字符串字段,如"3,4,5"
以下sql判断picclassids字段中是否存在@picclassids中的任何一个值
select * from t_pic where exists(select * from fn_split(picclassids,',') where a in (select * from fn_split(@picclassids,',')))