请帮忙看一下这段简单语句的错误。。

[dellair]

if exists(select * from sysobjects where name = 'counttable') drop table counttable
create table counttable(tablename nvarchar(20),record int)
declare @tablename nvarchar(20)
declare @i int
declare @sql nvarchar(200)
declare detail cursor for select [name] from sysobjects where type='u'
open detail
fetch next from detail into @tablename
while @@fetch_status = 0
begin
set @sql = 'select @i=count(*) from '+@tablename
exec @sql
insert into counttable(tablename,record) values(@tablename,@i)
fetch next from detail into @tablename
end
close detail
deallocate detail
select * from counttable

错误信息提示：未能找到存储过程 'select @i=count(*) from Orders'...

[dellair]

解决了，谢谢！

[dellair]

没有人来帮帮忙嘛，，，

[dellair]

哪位老大帮帮呀，在线等，，，

[dellair]

现在改成这样
if exists(select * from sysobjects where name = 'counttable') drop table counttable
create table counttable(tablename nvarchar(100),record int)
declare @tablename nvarchar(100)
declare @i int
declare @sql nvarchar(200)
declare detail cursor for select [name] from sysobjects where type='u'
open detail
fetch next from detail into @tablename
while @@fetch_status = 0
begin
set @sql = 'select @i = count(*) from '+ @tablename
exec(@sql)
insert into counttable(tablename,record) values(@tablename,@i)
fetch next from detail into @tablename
end
close detail
deallocate detail
select * from counttable

错误是：必须声明变量 '@i'。

[passionke]

set @sql = 'select @i = count(*) from '+ @tablename
exec(@sql)
改：
set @sql = 'select @i = count(*) from '+ @tablename
exec sp_executesql @sql, N'@i int output', @i output