SQL Server cursor usage

Declare @ chrname varchar (30)
Declare @ chryhm varchar (30)

Declare dw_only1 cursor for -- set the cursor to retrieve the record set for operation
Select chrname, chryhm from gzry where chrzw> = 5 order by chrzw DESC, intpxh -- select the position from the front and above
Open dw_only1
While (1> 0)
Begin
Fetch dw_only1 into @ chrname, @ chryhm
If (@ fetch_status =-1)
Begin
Close dw_only1
Deallocate dw_only1
Break
End
If (@ fetch_status =-2)
Begin
Close dw_only1
Deallocate dw_only1
Break
End
--- Select @ chrname, @ chryhm
-- Grant permissions to the corresponding person
Delete from yhmkqx where chryhm = @ chryhm and chrmkbm like '123'
Insert into yhmkqx (chryhm, chrmkbm) values (@ chryhm, '123 ')

End -------- end while