SQL insert cursors Explains how to insert a log of rows into a table efficiently. Understanding SQL insert cursors This is an introduction to SQL insert cursors. DECLARE (insert cursor) The DECLARE with an INSERT instruction defines an insert cursor. OPEN (insert cursor) Initializes an insert cursor. PUT (insert cursor) Adds a new row to the insert cursor buffer. FLUSH (insert cursor) Flushes the buffer of an insert cursor. CLOSE (insert cursor) Flushes and closes an insert cursor. FREE (insert cursor) Releases resources allocated for an insert cursor. Examples Insert cursor usage examples.