Create Procedure SP_DelLink
@ksid int,
@ksmc varchar(8),
@uplink int
@isValid char(4) output
AS
if not exists(select ksid from kstable where ksid=@ksid+1)
begin
delete from kstable where ksid=@ksid
select @isvalid="good"
end
else
if not exists(select ksid from kstable where ksid=@ksid+2)
begin
delete from kstable where ksid=@ksid+1
delete from kstable where ksid=@ksid
select @isvalid="good"
end
else
begin
delete from kstable where ksid=@ksid+2
delete from kstable where ksid=@ksid+1
delete from kstable where ksid=@ksid
select @isvalid="good"
end
select @isvalid="bad"
return