SQL cursor usage example

Copy codeThe Code is as follows:
DECLARE @ OldId varchar (50)
DECLARE @ CustomerID varchar (50)
DECLARE My_Cursor CURSOR -- defines the CURSOR
FOR (select CustomerID, oldid from Customer where Area = 'bj ') -- locate the desired set and put it in the cursor
OPEN My_Cursor; -- OPEN the cursor
Fetch next from My_Cursor INTO @ mermerid, @ OldId; -- read the first row of data
WHILE @ FETCH_STATUS = 0
BEGIN
DECLARE @ OtherPro VARCHAR (500)
DECLARE @ StatusID varchar (200)
DECLARE @ Userid varchar (200)
DECLARE @ FinalUserid varchar (200)

SELECT @ OtherPro = OtherPro, @ StatusID = CustomerStatusID, @ Userid = UserID FROM bjsunmis. dbo. Customer WHERE CustomerID = @ OldId;

SELECT @ FinalUserid = UserID from Users where oldid = @ Userid

Insert into CustomerotherInfo (CustomerID, OtherPro, CustomerStatusID, UserID) VALUES (@ CustomerID, @ OtherPro, @ StatusID, @ FinalUserid)

Fetch next from My_Cursor INTO @ mermerid, @ OldId; -- read the NEXT row of data
END
CLOSE My_Cursor; -- CLOSE the cursor
DEALLOCATE My_Cursor; -- release the cursor
GO