if exists (select 1 from sysobjects where type='P' and name ='tree_p_lujn')
DROP PROC tree_p_lujn
go
create proc tree_p_lujn(
@is_root_start_id varchar(100),
@is_table_name varchar(100),
@is_colume_id_name varchar(100),
@is_colume_parent_id_name varchar(100)
)
as
declare
@vn_pointer int,
@vn_lsmore int,
@vs_sql_temp varchar(2000)
begin
set @vs_sql_temp ="
create table #tmp(pid int not null,id int not null ,curr int not null,le varchar(255) not null)
--insert into #tmp values('-1','"+@is_root_start_id+"',-1,'.')
insert into #tmp
select 0,convert(int,t."+@is_colume_id_name+"),0,'.'+convert(varchar,t."+@is_colume_id_name+")
from "+@is_table_name+" t
where t."+@is_colume_parent_id_name+" ='"+@is_root_start_id+"'
set @vn_lsmore=@@rowcount,@vn_pointer=0
while(@vn_lsmore>0)
begin
insert into #tmp
select convert(int,t."+@is_colume_id_name+"),convert(int,t."+@is_colume_id_name+"),
@vn_pointer+1,u.le+'.'+convert(varchar,t."+@is_colume_id_name+")
from "+@is_table_name+" t,#tmp u
where convert(int,t."+@is_colume_parent_id_name+")=u.id and u.curr=@vn_pointer
set @vn_pointer=@vn_pointer+1,@vn_lsmore=@@rowcount
end
select t.* from "+@is_table_name+" t,#tmp u
where u.id=convert(int,t."+@is_colume_id_name+") order by le"
print @vs_sql_temp
exec (@vs_sql_temp)
return
end
----------测试-------------
exec tree_p_lujn '0','TBL_TEST','ID','PID'
分享到:
相关推荐
用Delphi编写 Sybase ESP (Extended store procedure)使用create procedure 安装此过程,需要启动xp_server
sybase stored procedure
INTRODUCING SYBASE IQ 15.3 WITH PlexQ TECHNOLOGY -2011-sybase-webcast-0822.pdf
Sybase16.0 简单介绍
OBDC驱动大全:OBDC驱动Sybase-oledb与OBDC驱动 MySql_connect; 解决部署遇到问题
4.打开SQL Advantage工具后,点菜单Server>Connect,在连接信息配置窗口中 其中Server列表中的Sybase服务名就是在第二步中配置的。Client host表示连接到Sybase 服务器中的客户端标志。 如果想配置网络包大小、...
sybase教sybase教程程sybase教程sybase教程sybase教程
this is book describe the sybase function and store procedure, and the function which supply by sybase. It's download by sybase website, and seems a good book who want to know more about sybase ...
sybase 客户端4sybase 客户端4sybase 客户端4sybase 客户端4sybase 客户端4sybase 客户端4sybase 客户端4sybase 客户端4sybase 客户端4sybase 客户端4sybase 客户端4sybase 客户端4
sybase 客户端2sybase 客户端2sybase 客户端2sybase 客户端2sybase 客户端2sybase 客户端2
sybase 的入门资料
Sybase 使用指导手册Sybase 使用指导手册Sybase 使用指导手册
su - sybase -c "/u/sybase/install/startserver -f /u/sybase/RUN_BACKUP_SERVR 1>/dev/null 2>/dev/null" 其中,SERVERNAME,RUN_BACKUP_SERVER分别为你的sybase服务器和备份服务器的名字。 七、登陆数据库后...
SybaseASE15.0 Enhanced Full-Text Search Specialty Data Store.pdf SybaseASE15.0 HA_故障切换.pdf SybaseASE15.0 Historical Server用户指南.pdf SybaseASE15.0 Job Scheduler用户指南.pdf SybaseASE15.0 Monitor...
sybase 客户端1 sybase 客户端1 sybase 客户端1 sybase 客户端1 sybase 客户端1 sybase 客户端1 sybase 客户端1 sybase 客户端1 sybase 客户端1
Sybase+PowerDesigner+15+破解
4、datax同步sybase相关-sybase到hdfs 网址:https://blog.csdn.net/chenwewi520feng/article/details/130508988 介绍sybase的相关同步,sybase到hdfs同步的示例及验证
windows下的sybase iq安装文档
sybase3驱动sybase3驱动sybase3驱动sybase3驱动sybase3驱动sybase3驱动sybase3驱动
Sybase ASE ODBC Driver 驱动