存储游标获得数据集问题 （急） 请高手指点

[earthgoshawk]

将表明作为参数，检查语法 在 Exec( @SQL ) 有错误。
用其他方法实现 动态表明也可以 请指点


create procedure prepeatcheck
@TableName varchar(20)
as

declare @name varchar(64),@SQL nvarchar(64),@count int ,
@name1 varchar(64)
--创建临时表

--================声明游标
set @SQL =N'select name,count(id) as count from '+@TableName+' group by name having count(id)>1 '
DECLARE cur_repeat CURSOR FOR
Exec( @SQL )
--打开游标
Open cur_repeat
Fetch Next FROM cur_repeat
INTO @name,@count
WHILE @@FETCH_STATUS=0
BEGIN
----
print('')
END
CLOSE cur_repeat
--销毁游标
DEALLOCATE cur_repeat

[wgsasd311]

set @SQL =N'select name,count(id) as count from '+@TableName+' group by name having count(id)>1 '
DECLARE cur_repeat CURSOR FOR
Exec( @SQL )
=====>
set @SQL =N'select name,count(id) as count from '+@TableName+' group by name having count(id)>1 '
Exec('DECLARE cur_repeat CURSOR FOR '+ @SQL )

[zlp321002]

DECLARE cur_repeat CURSOR FOR
Exec( @SQL )
------------->
没有得到返回值啊!

N'select @name=name,@count=count(id) as count from '+@TableName+' group by name having count(id)>1 '
exec sp_executesql @sql,N'@count int output,@name varchar(10) output',@count output,@name output