清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>
declare @t table(id int identity,col varchar(4)) declare @sql varchar(60) set @sql='吕布赵云马超典韦关羽张飞许褚黄忠颜良文丑庞德孙策' declare @i int;set @i=1 declare @n int;set @n=2 --定义分段长度 while(@i<len(@sql)) begin insert into @t select substring(@sql,@i,@n) set @i=@i+@n end select * from @t