How to use Database CURSOR

cursur

first create a table ...........

create table tbl_cursor
( ID int primary key not null,
name varchar(50) not null,
Gender char(1) not null

)

.....insert the data------
insert into tbl_cursor values (1,'om','M')
insert into tbl_cursor values (2,'ram','M')
insert into tbl_cursor values (3,'alice','F')
insert into tbl_cursor values (4,'grey','F')

select * from tbl_cursor

now create the cursor.......

DECLARE @ID BIGINT, @Gendar NVARCHAR(5)
DECLARE @MyCursor CURSOR
SET @MyCursor = CURSOR FOR (SELECT ID, Gendar FROM tbl_Curser ')
OPEN @MyCursor
FETCH NEXT FROM @MyCursor INTO @ID, @Gendar
WHILE @@FETCH_STATUS = 0
BEGIN
 IF(@Gendar = 'M')
 BEGIN
  UPDATE tbl_Curser SET Gendar = 'F' WHERE ID = @ID
 END
 IF(@Gendar = 'F')
 BEGIN
  UPDATE tbl_Curser SET Gendar = 'M' WHERE ID = @ID
 END
 FETCH NEXT
 FROM @MyCursor INTO @ID, @Gendar
END
CLOSE @MyCursor
DEALLOCATE @MyCursor