其中F_Split是分割以逗号连接的字符串的方法
怎么判断string字段拆分之后的数据是否能在@a表中的id字段找到对应的记录
insert into @a(id,name)values(1,'A')
insert into @a(id,name)values(2,'B')
insert into @a(id,name)values(3,'C')
select * from @a
insert into @c(statu,name,string)values('0','AAAAA','2,3')
insert into @c(statu,name,string)values('0','BBBBB','3,4')
insert into @c(statu,name,string)values('0','CCCCC','4,5')
select statu,name,string from @c
update @c set statu = 1
where (select col from F_Split(string,',')) in
(
select id from @a
)
select * from @c
以上代码有报错,请问该怎么写 ?