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