Cursor plays there row quite nicely but although there are some disadvantage of Cursor .
Because we know cursor doing roundtrip it will make network line busy and also make time consuming methods. First of all select query gernate output and after that cursor goes one by one so roundtrip happen.Another disadvange of cursor are ther are too costly because they require lot of resources and temporary storage so network is quite busy.
2 comments:
I copied all you post. Thanks lot for the sharing.
Hi
you are posting nice SQL sever interview questions answer and helping developer and DBA community. I have created a collection of few question answer also
Sql Server Interview faqs, questions & answers
Post a Comment