I think the more important question is how can you eliminate your cursor and therefore not really care about some of the subtle details. 😛

Honestly cursors are one the most resource intensive (and SLOW) methods of data manipulation available in sql server. There are a few very rare cases where a cursor is the only way to accomplish something. For everything else there is a much faster set based way of handling things.

If you really want to know the details about your question it can be answered here.