카테고리 없음

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