Stored Procedure using cursor

CREATE TABLE Orders (
OrderID int NOT NULL ,
CustomerID nchar (5) NULL ,
EmployeeID int NULL ,
OrderDate datetime NULL ,
RequiredDate datetime NULL ,
ShippedDate datetime NULL ,
ShipVia int NULL ,
Freight money NULL DEFAULT (0),
ShipName nvarchar (40) NULL ,
ShipAddress nvarchar (60) NULL ,
ShipCity nvarchar (15) NULL ,
ShipRegion nvarchar (15) NULL ,
ShipPostalCode nvarchar (10) NULL ,
ShipCountry nvarchar (15) NULL
)
--------------------------------------------
GO
INSERT INTO Orders VALUES (10248,'1',5,'7/4/1996','8/1/2001','7/16/2001',3,32.38,'V','A','R', NULL,N'51100','France')
go
-----------------------------------
alter PROCEDURE spCursorScope
AS
DECLARE @Counter int,
@OrderID int,
@CustomerID varchar(5)
DECLARE CursorTest cursor -----Declaring the cursor
LOCAL
FOR
SELECT OrderID, CustomerID
FROM Orders

SELECT @Counter = 1
OPEN CursorTest
FETCH NEXT FROM CursorTest INTO @OrderID, @CustomerID
PRINT 'Row ' + CONVERT(varchar,@Counter) + ' has an OrderID of ' +
CONVERT(varchar,@OrderID) + ' and a CustomerID of ' + @CustomerID

WHILE (@Counter<=5) AND (@@FETCH_STATUS=0)
BEGIN
SELECT @Counter = @Counter + 1
FETCH NEXT FROM CursorTest INTO @OrderID, @CustomerID
PRINT 'Row ' + CONVERT(varchar,@Counter) + ' has an OrderID of ' +
CONVERT(varchar,@OrderID) + ' and a CustomerID of ' + @CustomerID
END
GO

exec spCursorScope
go