'
declare @c1 varchar(100)='2531191'
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 ''+鍒嗙被+'>