34,594
社区成员
发帖
与我相关
我的任务
分享已经声明了,为什么还提示“必须声明变量@Num”
存储过程如下：
alter procedure getLoseNum
@TableName nvarchar(100)
as
create table #temptable(a int)
declare @char varchar(1000),@i int
declare @num int
exec('set @num=(select max(id) from '+@TableName+')')
set @i=1
while @i<=@num
begin
insert #temptable values (@i)
set @i=@i+1
end
exec ('select a from #temptable where a not in (select id from '+@TableName+')')
alter procedure getLoseNum
@TableName nvarchar(100)
as
create table #temptable(a int)
declare @char varchar(1000),@i int
declare @num int
exec('set @num=(select max(id) from '+@TableName+')')
set @i=1
while @i<=@num
begin
insert #temptable values (@i)
set @i=@i+1
end
exec ('select a from #temptable where a not in (select id from '+@TableName+')')
...全文
请发表友善的回复…
发表回复
快乐鹦鹉 2004-10-21
- 打赏
- 举报
exec('set @num=(select max(id) from '+@TableName+')')
这句话有问题。@num在这里被当成字符串了，而不是变量
这句话有问题。@num在这里被当成字符串了，而不是变量
Andy__Huang 2004-10-21
- 打赏
- 举报
alter procedure getLoseNum
@TableName nvarchar(100)
as
create table #temptable(a int)
declare @char varchar(1000),@i int
declare @num int
exec('set '+@num+'=(select max(id) from '+@TableName+')')---->改這一行
set @i=1
while @i<=@num
begin
insert #temptable values (@i)
set @i=@i+1
end
exec ('select a from #temptable where a not in (select id from '+@TableName+')')
@TableName nvarchar(100)
as
create table #temptable(a int)
declare @char varchar(1000),@i int
declare @num int
exec('set '+@num+'=(select max(id) from '+@TableName+')')---->改這一行
set @i=1
while @i<=@num
begin
insert #temptable values (@i)
set @i=@i+1
end
exec ('select a from #temptable where a not in (select id from '+@TableName+')')
