SQL 存储过程的问题:游标已经存在,哭了。

2025-02-26 01:47:40
推荐回答(2个)
回答1:

提示'My_Cursor'肯定是上次运行时没有删除。你把
Close @CarInfo_Cur;
Deallocate @CarInfo_Cur;
Exec RecreateWaittingID;
放到最后一个END后面去试试。

回答2:

Declare CarInfo_Cur Cursor For
Select State, CarNum, LastGetIn From CarInfo Where RFID=@Rfid And (DateDiff(minute,lastGetin, GetDate())>2) For Update;
Open CarInfo_Cur;
Fetch Next From CarInfo_Cur Into ....