Assertion: cursor's row | /r/HasProperty | updated
Facets:
value: the current row
type: OTHER
Source sentences:
text: If, during the update operation, there is an error, then no rows are updated.
text: It specifies that positioned updates or deletes made through the cursor do not succeed if the row has been updated since it was read into the cursor.
text: It specifies that positioned updates or deletes made through the cursor do not succeed if the row has been updated since it was read into the cursor.
text: If you check the records in customers table, you will find that the rows have been updated −
text: Cursors can not only be used to fetch data from the DBMS into an application but also to identify a row in a table to be updated or deleted.
text: Associate a cursor with the result set of a Transact-SQL statement, and define characteristics of the cursor, such as whether the rows in the cursor can be updated.
text: Specifies that positioned updates or deletes made through the cursor do not succeed if the row has been updated since it was read into the cursor.
text: Only one row is updated, the current row.
text: Because the cursor is semisensitive, this row was copied into the worktable before the row was updated, and the data change made by the update statement is invisible to the cursor, since the row returned comes from the result set scrolling worktable.
text: Since Row 4, (2002040, Sam, Burke) was fetched after “Sam” was updated to “Joe,” the returned employee ID 2002040 is Joe, Burke.