Create procedure test1 As ...Create procedure test2 As ... Exec test1 ...
马可: 我想让子存储过程(test1)中计算得出的一个值返回给上级存储过程(test2),在test2中用这个值,如何得到?下面是我得代码: CREATE PROCEDURE aaaUP_TEST AS SET NOCOUNT ON-------------------- declare @sqlcur varchar(7000) declare cur_rs cursor local for select max(right(name,len(name)-9)) as maxno from sysobjects where name like 'Temptable%' open cur_rs fetch cur_rs into @sqlcurwhile @sqlcur is null begin select @sqlcur=0 endselect @sqlcur=@sqlcur+1 -------------------------------declare @sqltab varchar(6000) select @sqltab=' CREATE TABLE temptable' + @sqlcur +' ( [日期] [smalldatetime] NULL, [机械番号] [Varchar](30) NULL, [数量] [decimal] NULL )' --print @sqltab exec (@sqltab)我想让两条横线之间的代码通过子存储过程实现,并将◎sqlcur返回,如何做?
create procedure test1 As -------------------- declare @sqlcur varchar(7000) declare cur_rs cursor local for select max(right(name,len(name)-9)) as maxno from sysobjects where name like 'Temptable%' open cur_rs fetch cur_rs into @sqlcurwhile @sqlcur is null begin select @sqlcur=0 endselect @sqlcur=@sqlcur+1 ------------------------------- Return @sqlcur gocreate procedure test2 As ... Exec @a = test1 select @a ...
As
...Create procedure test2
As
...
Exec test1
...
我想让子存储过程(test1)中计算得出的一个值返回给上级存储过程(test2),在test2中用这个值,如何得到?下面是我得代码:
CREATE PROCEDURE aaaUP_TEST AS
SET NOCOUNT ON--------------------
declare @sqlcur varchar(7000)
declare cur_rs cursor local for select max(right(name,len(name)-9)) as maxno from sysobjects where name like 'Temptable%'
open cur_rs
fetch cur_rs into @sqlcurwhile @sqlcur is null begin
select @sqlcur=0
endselect @sqlcur=@sqlcur+1
-------------------------------declare @sqltab varchar(6000)
select @sqltab='
CREATE TABLE temptable' + @sqlcur +'
(
[日期] [smalldatetime] NULL,
[机械番号] [Varchar](30) NULL,
[数量] [decimal] NULL
)'
--print @sqltab
exec (@sqltab)我想让两条横线之间的代码通过子存储过程实现,并将◎sqlcur返回,如何做?
As
--------------------
declare @sqlcur varchar(7000)
declare cur_rs cursor local for select max(right(name,len(name)-9)) as maxno from sysobjects where name like 'Temptable%'
open cur_rs
fetch cur_rs into @sqlcurwhile @sqlcur is null begin
select @sqlcur=0
endselect @sqlcur=@sqlcur+1
-------------------------------
Return @sqlcur
gocreate procedure test2
As ...
Exec @a = test1
select @a
...
exec test1 @sqlcur output
print @sqlcur