string_split
카테고리 없음 / 2023. 4. 17. 10:10
if object_id('tblx') is not null
drop table tblx
go
create table tblx (idx int identity(1,1))
go
insert into tblx default values;
go 10
select *
from tblx
where idx in
(
select cast(value as int)
from string_split('2,3', ',')
)
go