sqlserver数据批量模糊查询

create table t10(ID int,串码 varchar(20))

insert into t10
1, 'A0000000001' union all
select 2, 'A0000000002' union all
select 3, 'A0000000003' union all
select 4, 'A0000000004' union all
select 5, 'A0000000005' union all
select 6, 'A0000000006' union all
select 7, 'A0000000007'

-- 程序中输入的串@x
declare @x varchar(50)

select @x='A0000000003,A0000000006'

select * from t10
where 串码 between left(@x,charindex(',',@x)-1)
and substring(@x,charindex(',',@x)+1,20)

ID 串码
----------- --------------------
3 A0000000003
4 A0000000004
5 A0000000005
6 A0000000006