An attempt to SQL Server cursors

DECLARE @ProName NVARCHAR (50)
DECLARE @CityName NVARCHAR (50)
DECLARE @ProId INT
DECLARE @CityId INT
DECLARE Test_cursor Cursor for
SELECT A.areaid,a.areaname,b.areaname from Areafull as a right joins Areafull as B on A.areapid=b.areaid WHERE A.areapid> ; 34
OPEN Test_cursor
FETCH NEXT from Test_cursor to @CityId, @CityName, @ProName
While @ @FETCH_STATUS = 0
BEGIN
SET @ProId = (SELECT ID from dbo. Web_area WHERE [email protected] and orderid=27)
INSERT into Web_area (Name,headid,lv,family,orderid) VALUES (@CityName, @ProId, 4,4,28)
FETCH NEXT from Test_cursor to @CityId, @CityName, @ProName
END
CLOSE Test_cursor
Deallocate test_cursor

SELECT * FROM dbo. Web_area

An attempt to SQL Server cursors