Record the cursor used today: DECLARE @ TempIDINTDECLARE @ NumberINTSET@Number1DECLAREmyCursorCURSORFORSELECTMemberIDFROMdbo.MemberOPENmyCursorFETCHNEXTFROMmyCursorINTO @ TempIDWHILE (@ fetch_status0) BEGINUPDATEdbo. Member
Record the CURSOR used today: DECLARE @ TempID int declare @ Number int set @ Number = 1 DECLARE myCursor cursor for select MemberID FROM dbo. member OPEN myCursor fetch next from myCursor INTO @ TempID WHILE (@ fetch_status = 0) begin update dbo. member
Record what is used todayCursor:
DECLARE @ TempID INT
DECLARE @ Number INT
SET @ Number = 1
DECLARE myCursor CURSOR
SELECT MemberID FROM dbo. Member
OPEN myCursor
Fetch next from myCursor INTO @ TempID
WHILE (@ fetch_status = 0)
BEGIN
UPDATE dbo. Member
SET MemberName = 'test member '+ CONVERT (VARCHAR, @ Number, 50)
WHERE MemberID = @ TempID
SET @ Number = @ Number + 1
Fetch next from myCursor INTO @ TempID
END
CLOSE myCursor
DEALLOCATE myCursor
To be continued .....
DECLARE @ id INT
DECLARE @ money INT
DECLARE cursor1 CURSOR
SELECT IntegrateCardID, RemainSum FROM dbo. IntegrateCard
OPEN cursor1
Fetch next from cursor1 INTO @ temp, @ money
WHILE (@ fetch_status = 0)
BEGIN
UPDATE dbo. IntegrateCard
SET PreRecharge = @ money
WHERE IntegrateCardID = @ id
Fetch next from cursor1 INTO @ TempMemeberID
END
CLOSE cursor1
DEALLOCATE cursor1