34,838
社区成员




declare @c varchar(max)
set @c = ''
select @c = @c +'/'+ F_FULL_DEPT_ID from table1
set @c = replace(right(@c,len(@c)-1),'/',',')
exec('select * from table2 where ID in('+@c+')')
DECLARE @i varchar(10)
SET @i = '123'
DECLARE @value VARCHAR(200)
SET @value = '1/123/143/124546/'
SELECT CHARINDEX(@i,@value,0)
结果如果大于0 ,就判定为含有了哦。 不过这个不是非常严谨的,如果要非常严谨,lz需要拆分出来然后inner join 看看