本文介绍了一种使用SQL实现的字符串拆分方法，并将其应用到具体的数据插入操作中。通过设置循环来逐个处理字符串中的元素，并将它们分别插入到数据库表中。
环境如下 @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
代码如下
@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
扫一扫
4874
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
