Cleverly use the string after array join as the query Condition

Declare @ STR varchar (500) set @ STR = '1, 2, 3, 4, 5, 6, 7 'create table # temp (id int) Declare @ AAA varchar (8000) set @ AAA = 'insert # temp select * from (select ''' + Replace (@ STR, ',', ''' as STR Union all select ''') + ''') a' exec (@ AAA)

To obtain such a result set, find the record of the table. classid that appears in @ STR (@ STR is a parameter passed by the outside world). What should I do?

 

Select * from your table where exists (select 1 from # temp where your table. classid = # temp. ID)