要编两个存储过程实现如下的功能
EXEC SQL declare @cnt int;
EXEC SQL exec ge_number @cnt output; //取出参数
再让MNumber=cnt //再将取出的参数赋值给全局变量MNumber
EXEC SQL EXEC table_name :stable,:MNumber; //再在另外一个存储过程里面实现表名,参数都是变量的查询基于此,如下编写的两个存储过程要怎么修改啊
int stable,MNumber; //全局变量
EXEC SQL CREATE Procedure table_name
@tablename char(10),@ID int
As exec('insert into ' +@tablename+ ' values(' +@ID+ ',1,1,1,1,1,1,1,1,1,1)'); //1EXEC SQL CREATE Procedure ge_number
@table nvarchar(50),
@cnt int output
AS
declare @sql nvarchar(100)
set @sql=N'select @cnt=number into :MNumber from '+@table
exec sp_executesql @sql ,N'@cnt int output' , @cnt output; //2大侠帮帮忙啦
EXEC SQL declare @cnt int;
EXEC SQL exec ge_number @cnt output; //取出参数
再让MNumber=cnt //再将取出的参数赋值给全局变量MNumber
EXEC SQL EXEC table_name :stable,:MNumber; //再在另外一个存储过程里面实现表名,参数都是变量的查询基于此,如下编写的两个存储过程要怎么修改啊
int stable,MNumber; //全局变量
EXEC SQL CREATE Procedure table_name
@tablename char(10),@ID int
As exec('insert into ' +@tablename+ ' values(' +@ID+ ',1,1,1,1,1,1,1,1,1,1)'); //1EXEC SQL CREATE Procedure ge_number
@table nvarchar(50),
@cnt int output
AS
declare @sql nvarchar(100)
set @sql=N'select @cnt=number into :MNumber from '+@table
exec sp_executesql @sql ,N'@cnt int output' , @cnt output; //2大侠帮帮忙啦
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货