How to use cursor in Sql server with example

DECLARE @MAINTABLE1 TABLE (PERSON_ID INT)

insert into @MAINTABLE1 VALUES(1)
insert into @MAINTABLE1 VALUES(2)
insert into @MAINTABLE1 VALUES(3)
insert into @MAINTABLE1 VALUES(4)
insert into @MAINTABLE1 VALUES(5)

--declare Cursor
DECLARE CUR CURSOR FOR
--select column for cursor looping
SELECT PERSON_ID FROM @MAINTABLE1
--declare loop variable
DECLARE @PERSON_ID int
--open cursor
OPEN CUR
FETCH NEXT FROM CUR INTO @PERSON_ID
WHILE @@FETCH_STATUS =0
BEGIN

    --opration like print ,insert,update,delete,etc
    print @PERSON_ID
    FETCH NEXT FROM CUR INTO @PERSON_ID
END
--close cursor
CLOSE CUR
--free momory
DEALLOCATE CUR