VIP会员
购物车
私信
发表新帖
立即签到
关注
回复
支持(
反对(
首页上一页 1 下一页尾页 1 条记录 1/1页
请解释实例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的代码.但看不懂,能否详细解释一下?谢谢!
分享到：
