Syntax for Cursor in SQL Server

CREATE PROCEDURE sp_Test()
as

DECLARE @colA nvarchar(10)
DECLARE @colB nvarchar(10)
DECLARE @MyCursor CURSOR

SET @MyCursor = CURSOR FAST_FORWARD
FOR
Select colA,colB
From tableA

OPEN @MyCursor
FETCH NEXT FROM @MyCursor
INTO @ColA,@ColB

WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @ColA
PRINT @ColB
FETCH NEXT FROM @MyCursor
INTO @ColA,@ColB
END

CLOSE @MyCursor
DEALLOCATE @MyCursor
GO