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
