Post reply

what is use of cursors? how it is used?

  • August 9, 2005 at 5:40 am

    #165553

    what is use of cursors? how it is used?

  • August 9, 2005 at 6:05 am

    #580659

    Good question .  As far as I'm concerned cursors are of no use whatsoever (in 99.999% of occasions).

    A cursor allows you to build a record set and then execute some logic based on each entry in the list.  They are often notoriously slow and you should always try to avoid them where possible in favour of a set based solution instead.

    I know that this probably hasn't answered your question in the way you wanted but I do think it's the correct way of answering it.

    Mike

  • August 9, 2005 at 6:29 am

    #580669

    Yup... 2000+ sps and counting : 0 cursor needed.

  • August 9, 2005 at 6:41 am

    #580678

    No doubt 500+ occasions where you could have used one but chose not to

  • August 9, 2005 at 6:49 am

    #580684

    Could've used one 100% of the time... but there always was a better way.

  • August 9, 2005 at 9:29 am

    #580780

    Now you'll have to explain "set based solution"   !!   🙂

  • August 9, 2005 at 11:12 am

    #580813

    Not the right person asking .

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply