sql2000存储过程 截取字符串

来源:互联网 发布:ubuntu切换搜狗输入法 编辑:程序博客网 时间:2024/04/29 20:36
环境如下 @Receiver="1,2,3,4,5,8,"  截取receiver
代码如下
@Receiver="1,2,3,4,5,8,"
declare @i  int

   set @i=0

    while (@i<=len(@Receiver))
    begin
       set @i=charindex(',',@Receiver)
       insert into T_Document_User (DocID,Receiver) values(@DocID,left(@Receiver,@i-1))
       set @Receiver=right(@Receiver,len(@Receiver)-@i)
    end
原创粉丝点击