Thanks to everyone for taking the time to read my post and reply.

I agree with what has been said about cursors being a last resort and that there are better alternatives in most cases.

I was really just asking the question out of interest, in that it seems strange to have two cursor types that, from their description on MSDN, appear to be nearly identical.