首頁猿問關(guān)鍵字...

關(guān)鍵字 'for' 附近有語法錯誤？

SQL Server

慕姐4208626 2022-09-16 11:11:31

declare @PtnLimitTime datetimedeclare @cursor CURSOR forSelect PtnLimitTime from tblPlanTableNameopen @cursorfetch next from @cursor into @PtnLimitTimewhile(@@fetch_status=0)beginprint @PtnLimitTimefetch next from @cursor into @PtnLimitTimeendclose @cursordeallocate @cursor錯誤提示：消息 156，級別 15，狀態(tài) 1，第 3 行關(guān)鍵字 'for' 附近有語法錯誤。錯誤提示：消息 156，級別 15，狀態(tài) 1，第 2行關(guān)鍵字 'for' 附近有語法錯誤。弄錯提示了。

查看完整描述

2 回答

肥皂起泡泡

TA貢獻(xiàn)1829條經(jīng)驗(yàn) 獲得超6個贊

把cursor名前面的@去掉，如下：

declare cursor_1 CURSOR for
Select PtnLimitTime from tblPlanTableName
open cursor_1
fetch next from cursor_1 into @PtnLimitTime
while(@@fetch_status=0)begin
print @PtnLimitTime
fetch next from cursor_1 into @PtnLimitTime
end
close cursor_1
deallocate cursor_1

反對回復(fù) 2022-09-21

智慧大石

TA貢獻(xiàn)1946條經(jīng)驗(yàn) 獲得超3個贊

declare @PtnLimitTime datetime
declare cursor1 CURSOR for
Select PtnLimitTime from tblPlanTableName
open cursor1
fetch next from cursor1 into @PtnLimitTime
while(@@fetch_status=0)begin
print @PtnLimitTime
fetch next from cursor1 into @PtnLimitTime
end
close cursor1
deallocate cursor1