截取字符串1，2，3，4，5

最新推荐文章于 2024-05-06 21:41:01 发布

weixin_30784945

最新推荐文章于 2024-05-06 21:41:01 发布

阅读量114

点赞数

原文链接：http://www.cnblogs.com/Garden-blog/archive/2011/06/14/2080372.html

版权

declare @split varchar(2)
set @split=','

while(CHARINDEX(@split,@SalesDate)<>0)
   begin
    insert into SP_SpecialsCommodityEveryday
    (
     S_Id,C_Id,SalesWeek,LimitAmount
    )
    values
    (
     @return_Id,@C_Id,substring(@SalesDate,1,charindex(@split,@SalesDate)-1),@LimitAmount
    )

    IF( @@ERROR <> 0 )
    BEGIN
     GOTO Cleanup
    END
    set @SalesDate=stuff(@SalesDate,1,CHARINDEX(@split,@SalesDate),'')
   end

if @SalesDate<>''
   begin
    insert into SP_SpecialsCommodityEveryday
    (
     S_Id,C_Id,SalesWeek,LimitAmount
    )
    values
    (
     @return_Id,@C_Id,@SalesDate,@LimitAmount
    )

    IF( @@ERROR <> 0 )
    BEGIN
     GOTO Cleanup
    END
   end

转载于:https://www.cnblogs.com/Garden-blog/archive/2011/06/14/2080372.html