Sybase查询求教.....急急急.....
在SYBASE中如何实现递归查询
例如ORACLE中的 start by .... connect by
[解决办法]
CREATE procedure bitGetsaltSort (
@saltSort nvarchar( 50 ), --查询的盐种名称
@wcis_00802 nvarchar( 50 ), --盐父类编号
@result bit output
)
AS
declare @w00802 nvarchar(50),@w00803 nvarchar(50)
select @w00802 = (SELECT WCIS_00802 FROM WCISTA_008 WHERE WCIS_00801 = @wcis_00802),
@w00803 = (SELECT WCIS_00803 FROM WCISTA_008 WHERE WCIS_00801 = @wcis_00802)
IF @w00802 = '0'
begin
select @result = 0
end
else
if @w00803 = @saltSort
begin
select @result = 1
end
else
begin
execute bitGetsaltSort @saltSort,@w00802,@result output
end
[解决办法]
http://www.2cto.com/database/201203/124955.html
