In this page you can learn how to delete rows from table and views using delete operation in cursors.
Delete in cursors example:
DECLARE MyCursor CURSOR FOR
WHERE first_name = 'David' AND last_name = 'BROWN' AND id = 6 ;
FETCH FROM MyCursor;
DELETE FROM dbo.students WHERE CURRENT OF MyCursor;