declare @InpS nvarchar(max)='ACP,LeasingIndividualUsedCarNonCertified' select @InpS,len(@InpS),charindex(',',@InpS),substring(@InpS,charindex(',',@InpS)+1,len(@InpS))
SQL SERVER 字符串分割用substring
发布时间 2023-11-29 16:21:54作者: hofmann
declare @InpS nvarchar(max)='ACP,LeasingIndividualUsedCarNonCertified' select @InpS,len(@InpS),charindex(',',@InpS),substring(@InpS,charindex(',',@InpS)+1,len(@InpS))