您可以创建一个有序的拆分函数：
CREATE FUNCTION [dbo].[SplitStrings_Ordered]( @List NVARCHAr(MAX), @Delimiter NVARCHAr(255))RETURNS TABLEAS RETURN (SELECt [Index] = ROW_NUMBER() OVER (ORDER BY Number), Item FROM (SELECt Number, Item = SUBSTRINg(@List, Number, CHARINDEX(@Delimiter, @List + @Delimiter, Number) - Number) FROM (SELECt ROW_NUMBER() OVER (ORDER BY s1.[object_id]) FROM sys.all_objects AS s1 CROSS JOIN sys.all_objects AS s2) AS n(Number) WHERe Number <= ConVERT(INT, LEN(@List)) AND SUBSTRINg(@Delimiter + @List, Number, LEN(@Delimiter)) = @Delimiter ) AS y);
然后略微更改您的输入（一个逗号分隔的列表，而不是三个单独的字符串）：
SELECt p.ID, p.NAME FROM dbo.PERSONS AS pINNER JOIN dbo.SplitStrings_Ordered('BBB,AAA,ZZZ', ',') AS sON p.NAME = s.ItemORDER BY s.[Index];
