It sounds like you're interested in the VS Cursor 12.0 Extended
DECLARE myCursor CURSOR EXTENDED LOCAL FAST_FORWARD FOR
SELECT OrderID, TotalAmount FROM Orders WHERE Status = 'Pending';
Some popular DBMS have cursor features, such as:
Select the "VS Cursor 12.0 Extended" scheme from the dropdown menu and hit Apply. Premium vs. Extended
Best for: