游Cursor的select_statement句中如何使用量
想一量中取得表名，然后作游中查句所用到的Table
具代如下：select 句中提示必需定量 @tablename ，我的目的就是必需用一量代替表名，望高手指啊！！

declare @dateid nvarchar(8)
declare @tablename nvarchar(20)

set @tablename = 'myTable '

DECLARE cur_Infor_1 CURSOR FOR

SELECT dateid FROM @tablename

OPEN cur_Infor_1

FETCH NEXT FROM cur_Infor_1 INTO @dateid

WHILE @@fetch_status=0

BEGIN

if(@dateid = '20070324 ')

print 'Success : ' + @dateid
else
print 'Failed : ' + @dateid

FETCH NEXT FROM cur_Infor_1 INTO @dateid

END

CLOSE cur_Infor_1

DEALLOCATE cur_Infor_1


[解决办法]
exec( 'DECLARE cur_Infor_1 CURSOR FOR

SELECT dateid FROM '+@tablename)