22,210
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM tbBusiness WHERE Business_Class_fk = 0 AND Business_Code_pk IN (“1199,1025,1493,1859,569,225,1581,549,1277") order by charindex(','+ltrim(Business_Code_pk)+',', ',1199,1025,1493,1859,569,225,1581,549,1277,')"
create table tbBusiness
(Business_Class_fk int,Business_Code_pk int)
insert into tbBusiness select 0,'1199'
union all select 0,'1025'
union all select 0,'1493'
union all select 0,'1859'
union all select 0,'569'
union all select 0,'225'
union all select 0,'1581'
union all select 0,'549'
union all select 0,'1277'
SELECT * FROM tbBusiness WHERE Business_Class_fk = 0 AND Business_Code_pk IN (1199,1025,1493,1859,569,225,1581,549,1277)
order by charindex(','+cast(Business_Code_pk as varchar(20))+',', ',1199,1025,1493,1859,569,225,1581,549,1277,')
drop table tbBusiness
create table tbBusiness
(Business_Class_fk int,Business_Code_pk varchar(20))
insert into tbBusiness select 0,'1199'
union all select 0,'1025'
union all select 0,'1493'
union all select 0,'1859'
union all select 0,'569'
union all select 0,'225'
union all select 0,'1581'
union all select 0,'549'
union all select 0,'1277'
SELECT * FROM tbBusiness WHERE Business_Class_fk = 0 AND Business_Code_pk IN ('1199','1025','1493','1859','569','225','1581','549','1277')
order by charindex(','+Business_Code_pk+',', ',1199,1025,1493,1859,569,225,1581,549,1277,')
drop table tbBusiness
---------------------
0 1199
0 1025
0 1493
0 1859
0 569
0 225
0 1581
0 549
0 1277
SELECT * FROM tableName WHERE Class = '0' and Id in (252, 679, 321, 100, 270)
order by charindex(','+ltrim(Id)+',', ',252,679,321,100,270,')