请解释实例151的代码
发表在Oracle视频答疑
2010-03-15
是否精华
是
否
版块置顶:
是
否
declare @i nvarchar(50);set @i='';
select @i=@i+b.c
from(
select substring(a.n,iter.pos,1) as c
from (select 'as#df*4,56' as n)a ,
(select id as pos from tb_num06)iter
where iter.pos<=len(a.n))b
where ascii(b.c) between 48 and 122;
select @i
以上是实例151的代码.但看不懂,能否详细解释一下?谢谢!
select @i=@i+b.c
from(
select substring(a.n,iter.pos,1) as c
from (select 'as#df*4,56' as n)a ,
(select id as pos from tb_num06)iter
where iter.pos<=len(a.n))b
where ascii(b.c) between 48 and 122;
select @i
以上是实例151的代码.但看不懂,能否详细解释一下?谢谢!