将逗号分隔的字符串,每个都单独打印出来
declare @xt varchar(max)
declare @channel varchar(32)
set @xt='2437fc26c8ad442e9b48aea4f90b91b0,29c17ae6463d4072a13c14b2bbdcd589,2a7ea11fe4b14c47894714d908b403ca,2d184c8dda7d447c8e6d2141ac43552a,2f50c4c592314701a2df92227a19a9cf,2f958bf7882644fa8f4cfeba7eae8273,3103469d07734fbcac35cba548eb5a57,4070aa6e4d594c9290431ced954f8dfc,52e6862d32c449f1bc595d7fa9b3aaf5,549f27221dfc43c3a67c803470381c9b,5ab1215648674994ba73f3f4e7529a30,63c54a0a66ee49c380eeca85b9c48996,693256e7e61840498e7dae6746f6ab95,70a864c99f1a42d79b9cd6ff3718794f,7ab49237af954be0b673116a0464b8f8,8c06c8ce223342a1afbbc82c20ba0a01,8e316669ab464c5eb3af5ce7fac4fc8a,9618b7fde03d41efa22369c4daabda43,96da6b89a49f497ea7c5cdf7e7c90109,98952096d5564d96863b7ef786ab093d,98b1e831a42943e4ad96911d9015f3bd,9c6dd7767bb749589df38e75cf1d2883,c07a358131bb4c4bb3367e8e54eca333,c9d19c36891a4dc98403f3399ef743db,d3888e2b51e44d1d9a9289cc8a8f4d5f,ddf85e93bfd74c3e8bca6c4b6d077e5b,e37c65768dfd42809c765c39e42df31e,fddb89579dba4795bc4db0382179c611'
while LEN(@xt)>0 --charindex(',',@xt)>0
begin
-- print charindex(',',@xt)
set @channel=left(@xt,32)
-- print 'len='+CAST(LEN(@xt) as varchar)
if LEN(@xt)<33
begin
-- 最后一个
set @xt=RIGHT(@xt,32)
set @channel=left(@xt,32)
print @channel
break
end
else
begin
set @xt=RIGHT(@xt,LEN(@xt)-33)
print @channel
end
end
执行效果: