sqlServer避免in查询自动排序

使用 CHARINDEX(cast(C.value as NVARCHAR(20)),‘主键,卖方编码,卖方名称,买方编码,卖方级别’)

SELECT B.name AS columnName 
 FROM sys.tables A
 INNER JOIN sys.columns B
 ON B.object_id = A.object_id
 LEFT JOIN sys.extended_properties C
 ON C.major_id = B.object_id AND C.minor_id = B.column_id
 WHERE A.name = 't_rebate_imp_com_contract_tzero' AND C.value IN ( '主键' , '卖方编码' , '卖方名称' , '买方编码' , '卖方级别' )
 order by 
 CHARINDEX(cast(C.value as NVARCHAR(20)),'主键,卖方编码,卖方名称,买方编码,卖方级别')