看看这里：在SQL IN子句中使用逗号分隔值参数字符串 [ ^ ]

你会发现一种如何创建函数将字符串拆分成部分的方法。



另一种方法是创建 CTE [ ^ 一>]。检查我过去的答案：

分开同一列的多个值 [ ^ ]

通过使用T-Sql分割长字符串来获取第2和第3个字符串 [ ^ ]



您需要做的就是将分隔符从[，]更改为[ @ ]



注意，SQL Server 2016具有内置功能： STRING_SPLIT（Transact-SQL） - SQL Server | Microsoft Docs [ ^ ]

Take a look here: Using comma separated value parameter strings in SQL IN clauses[^]
There you'll find a way how to create a function to split string into parts.

Another way is to create CTE[^]. Check my past answers:
separate multiple values for the same column[^]
get 2nd and 3rd string by splitting a long string using T-Sql[^]

All you need to do is to change a separator from [,] to [@]

Note, that SQL Server 2016 has got in-built function: STRING_SPLIT (Transact-SQL) - SQL Server | Microsoft Docs[^]

您是否可能想要从SPLIT中获取PIVOT表？

我所在的实例没有SQL Split_String函数，只有一个列函数...您可能需要根据您的机器设置进行调整

Could you possibly be wanting a PIVOT table being sourced from a SPLIT?
The instance I am on does not have the SQL Split_String function, only a single column function... you may need to adjust depending on your machines setup

DECLARE @entry NVARCHAR(100) = 'c1@c2@c3@c4@c5@c6@c7@c8@c9'
DECLARE @parse TABLE (RowN INT identity(1,1) NOT NULL, element NVARCHAR(100))

INSERT  @parse (element)
SELECT  Val
FROM    dbo.fnSplitString(@entry, '@')

SELECT  ColumnName = 'data', [1], [2], [3], [4], [5], [6], [7], [8]
FROM	(  SELECT  RowN, element
           FROM    @parse									 
) AS SourceTable

PIVOT	(  Max(Element)
           FOR RowN IN ([1], [2], [3], [4], [5], [6], [7], [8])
) AS PivotTable

将返回

Which will return

ColumnName  1   2   3   4   5   6   7   8
----------  --  --  --  --  --  --  --  --
data        c1  c2  c3  c4  c5  c6  c7  c8