ALTER PROCEDURE kp
@fp varchar(20)
AS
create TABLE #t(fpbh varchar(10) null,
nbxh int null) declare @fpbh varchar(10),
@nbxh int insert into #t(fpbh,nbxh) SELECT fpbh,nbxh
from ykfpsp
where ykfpsp.fpbh = @fpselect fpbh,nbxh from #tdrop table #t
@fp varchar(20)
AS
create TABLE #t(fpbh varchar(10) null,
nbxh int null) declare @fpbh varchar(10),
@nbxh int insert into #t(fpbh,nbxh) SELECT fpbh,nbxh
from ykfpsp
where ykfpsp.fpbh = @fpselect fpbh,nbxh from #tdrop table #t
不太懂,好像一句就可以,
SELECT fpbh,nbxh
from ykfpsp
where ykfpsp.fpbh = @fp
@fp varchar(20)
AS
create TABLE #t(fpbh varchar(10) null,
nbxh int null) declare @fpbh varchar(10),
@nbxh int if EXIST (select fpbh,nbxh from ykfpsp where ykfpsp.fpbh=@fp)
return 0
else
begin
select @fpbh=fpbh,@nbxh=nbxh
from ykfpsp
where ykfpsp.fpbh = @fp
insert into #t(fpbh,nbxh) SELECT @fpbh,@nbxh
from ykfpsp
where ykfpsp.fpbh = @fp
end
select @fpbh,@nbxh from #tdrop table #t
ALTER PROCEDURE kp
@fp varchar(20)
AS
SELECT fpbh,nbxh
from ykfpsp
where fpbh = @fp
insert into #t
select fpbh,nbxh
from ykfpsp
where ykfpsp.fpbh = @fp