字段1 字段2
1 fkdsaewewjkeljelwjelwkejewlkew
2 ddsadsadadsadsadqwqwqewqeqwe
用sqlserver操作，如何将字段中的记录每隔5个字符就在后面加一个,然后以新的记录存放到表中.如fkdsa,ewewj,kelje,......
------解决方案--------------------------------------------------------
- SQL code
--> 测试数据: @T--创建个自定义函数create function fn_insertsign(@str varchar(100))returns varchar(100)asbegin declare @i INT,@j int select @i=ceiling(len(@str)/5.00), @j=0 declare @s varchar(100) set @s='' while (@j<@i) begin set @s=@s+substring(@str,@j*5+1,5)+',' set @j=@j+1 end return @send--测试数据declare @T table (字段1 int,字段2 varchar(100))insert into @Tselect 1,'fkdsaewewjkeljelwjelwkejewlkew' union allselect 2,'ddsadsadadsadsadqwqwqewqeqwe'--更新数据update @T set 字段2=dbo.fn_insertsign(字段2)select * from @T/*字段1 字段2----------- ----------------------------------------1 fkdsa,ewewj,kelje,lwjel,wkeje,wlkew,2 ddsad,sadad,sadsa,dqwqw,qewqe,qwe,*/