Learn how to master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier.

If a row is deleted, an attempt to fetch the row returns an @@FETCH_STATUS of -2. Updates of key values from outside the cursor resemble a delete of the old row followed by an insert of the new row.