what is the alternate of cursor?

Question

Hi All, What is the alternate for cursor? Thanks To All

Manav Pandya · Answer

Hello As per my knowledge cursor itself is alternative for View / Subquery Cursor is provideing performance and other banefits over views and subquery For more reference you can follow : http://www.dotnettricks.com/learn/sqlserver/sql-server-cursor-alternatives https://blogs.msdn.microsoft.com/sqlprogrammability/2008/03/18/increase-your-sql-server-performance-by-replacing-cursors-with-set-operations/ http://www.c-sharpcorner.com/uploadfile/skumaar_mca/cursors-and-alternative-to-the-cursors-in-sql-server/ Thanks

Nitin Sontakke · Answer

In addition to what Manish Kumar has said, here is the list of all the question(s) you have asked. Please DO NOT get me wrong. You can ask as many questions as you want. The forum is for that only. But here is my observation. The kind of answer you will get is what I call a knowledge in fragments. It is not going to take you anywhere. You must understand how things fit together. Many of the questions I have seen above are actually very tricky. The are formed in such a fashion that only an experianced person will be able to answer them correctly. I suggest you try to get some COMPREHENSIVE knowledge about SQL Server by reading books like Microsoft SQL Server Unleashed series, do some formal online FREE courses and try to get some hands on knowledge. My reply WILL look / sound bitter to you but remember that it is the honest response.

Suraj Kumar · Answer

Hello, You can use while in place of cursor. To know more about difference between both go to below link https://social.msdn.microsoft.com/Forums/sqlserver/en-US/ba15132e-c26d-4472-92e9-845ce2cc244d/cursors-vs-while-loop?forum=transactsql Thanks

Manish Kumar · Answer

why don't you put all your interview question in one question .Also before asking in any forum check your self on google and if any issue then ask here.

Sanwar Ranwa · Answer

http://www.c-sharpcorner.com/UploadFile/ff2f08/cursor-alternative-in-sql-server/

what is the alternate of cursor?

Answers (5)