declare @InpS nvarchar(max)='ACP,LeasingIndividualUsedCarNonCertified'
select @InpS,len(@InpS),charindex(',',@InpS),substring(@InpS,charindex(',',@InpS)+1,len(@InpS))
SQL SERVER 字符串分割用substring
最新推荐文章于 2024-04-29 23:47:34 发布
declare @InpS nvarchar(max)='ACP,LeasingIndividualUsedCarNonCertified'
select @InpS,len(@InpS),charindex(',',@InpS),substring(@InpS,charindex(',',@InpS)+1,len(@InpS))