'
declare @c1 varchar(100)='2138539'
declare @c2 varchar(100)
declare @c3 varchar(100)
declare @c4 varchar(100)
declare @级别 varchar(1)
declare @分类 varchar(100)
select @级别=cast((select 级别 from web_jkhd..产品分类 where id=@c1) as varchar(1))
select @分类=(select 分类 from web_jkhd..产品分类 where id=@c1)
if (select 级别 from web_jkhd..产品分类 where id=@c1)>1
select @c2=(select rtrim(cast(parentid as varchar)) from web_jkhd..产品分类 where id=@c1)
if (select 级别 from web_jkhd..产品分类 where id=@c2)>1
select @c3=(select rtrim(cast(parentid as varchar)) from web_jkhd..产品分类 where id=@c2)
if (select 级别 from web_jkhd..产品分类 where id=@c3)>1
select @c4=(select rtrim(cast(parentid as varchar)) from web_jkhd..产品分类 where id=@c3)
/*产品分类:---------------------------------------------------*/
select '
产品分类:
'
select ''+分类+'>' from web_jkhd..产品分类 where id=@c4
select ''+分类+'>