create procedure P_Compute_DayDL
(@nian smallint, @qid smallint output,@fval real output)
-------程序代码
***************************************************************
----调用
create PROCEDURE dbo.P_Compute_DayReport(@year int)
decalre @qq smallint
declare @ff real
exec P_Compute_DayDL @year , @qq output ,@ff output
(@nian smallint, @qid smallint output,@fval real output)
-------程序代码
***************************************************************
----调用
create PROCEDURE dbo.P_Compute_DayReport(@year int)
decalre @qq smallint
declare @ff real
exec P_Compute_DayDL @year , @qq output ,@ff output
exec 存储过程Bselect * from #temptable
不知是否能满足要求。
as
create table #temptable(......)
insert #temptable exec B..........go
RETURNS @a TABLE
(
表结构定义
)AS
BEGIN
--处理过程,比如
INSERT @a SELECT * FROM table2
RETURN
END
goCREATE PROCEDURE A
AS
SELECT * from A()
GO
create procedure B
as
select * from a
gocreate procedure A
as
if object_id('tempdb..#t') is not null
begin
insert into #t
exec B
end