declare @sql varchar(5000),@totalLength int,@length int,@tag varchar(20),@currentNumber int
set @sql='a,v,c,'
print @Str
set @tag=','
set @totalLength=len(@sql)
set @length=charindex(@tag,@sql)
print '第1条记录:'+left(@sql,@length-1)
if(left(@sql,@length-1)>0)
begin
set @ret=1
end
set @sql=substring(@sql,@length+1,@totalLength)
set @currentNumber=1
while (@length>0)
begin
set @currentNumber=@currentNumber+1
set @length=charindex(@tag,@sql)
if(@length=0)
begin
break;
end
print '第'+ltrim(str(@currentNumber))+'条记录:'+left(@sql,@length-1)
set @sql=substring(@sql,@length+1,@totalLength)
end
SqlServer数据库截取字符串,获取字符串前后的值
最新推荐文章于 2024-03-22 09:31:34 发布