USE tempdb GO DECLARE @config NVARCHAR(200) SELECT @config='192.168.1.6,1234,123456789012,10,EF_EF,QWE1234,ASC12344,SMS_ZG_DAFY'SELECT config=LEFT(config,CHARINDEX(',',config,CHARINDEX(',',config)+1))+RIGHT(config,CHARINDEX(',',REVERSE(config),CHARINDEX(',',REVERSE(config))+1)-1) FROM (SELECT STUFF(@config,CHARINDEX(',',@config),CHARINDEX(',',@config,CHARINDEX(',',@config)+1)-CHARINDEX(',',@config),'') AS config)t/* 192.168.1.6,123456789012,ASC12344,SMS_ZG_DAFY */把變量換為列名
GO
DECLARE @config NVARCHAR(200)
SELECT @config='192.168.1.6,1234,123456789012,10,EF_EF,QWE1234,ASC12344,SMS_ZG_DAFY'SELECT
config=LEFT(config,CHARINDEX(',',config,CHARINDEX(',',config)+1))+RIGHT(config,CHARINDEX(',',REVERSE(config),CHARINDEX(',',REVERSE(config))+1)-1)
FROM
(SELECT STUFF(@config,CHARINDEX(',',@config),CHARINDEX(',',@config,CHARINDEX(',',@config)+1)-CHARINDEX(',',@config),'') AS config)t/*
192.168.1.6,123456789012,ASC12344,SMS_ZG_DAFY
*/把變量換為列名
但如果你的数据中1234,123456789012,10,EF_EF,QWE1234,ASC12344这些部分是要按特定规则选取的话就复杂一些了,最好是配合正则表达式来做