declare @dVouchDate datetime
declare @cInvCode nvarchar(30) DECLARE @CursorVar CURSOR
SET @CursorVar = CURSOR SCROLL DYNAMIC
For select dVouchDate,cInvCode from Temp20090916110500 group by dVouchDate,cInvCode
OPEN @CursorVar
FETCH NEXT FROM @CursorVar into @dVouchDate,@cInvCode
WHILE @@FETCH_STATUS = 0
BEGIN
print '11'
FETCH @CursorVar into @dVouchDate,@cInvCode
END
CLOSE @CursorVar
DEALLOCATE @CursorVar 记录集“select dVouchDate,cInvCode from Temp20090916110500 group by dVouchDate,cInvCode”中的表名可以是变量 吗? 比如是这样写 :select dVouchDate,cInvCode from @cTableName group by dVouchDate,cInvCode。
我自己试了一下,错误提示:必须声明表变量 "@cTableName"。
declare @cInvCode nvarchar(30) DECLARE @CursorVar CURSOR
SET @CursorVar = CURSOR SCROLL DYNAMIC
For select dVouchDate,cInvCode from Temp20090916110500 group by dVouchDate,cInvCode
OPEN @CursorVar
FETCH NEXT FROM @CursorVar into @dVouchDate,@cInvCode
WHILE @@FETCH_STATUS = 0
BEGIN
print '11'
FETCH @CursorVar into @dVouchDate,@cInvCode
END
CLOSE @CursorVar
DEALLOCATE @CursorVar 记录集“select dVouchDate,cInvCode from Temp20090916110500 group by dVouchDate,cInvCode”中的表名可以是变量 吗? 比如是这样写 :select dVouchDate,cInvCode from @cTableName group by dVouchDate,cInvCode。
我自己试了一下,错误提示:必须声明表变量 "@cTableName"。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货