How to use cursor in sqlserver step by step procedure

Question

Akkiraju Ivaturi · Answer

I understand what I have mentioned is not relevant to the question. But a suggestion.

Akkiraju Ivaturi · Answer

But make sure that unless it is needed do not use cursors. It has performance issues. Instead use the while loop to go through the data and process each row or use Common Table Expressions if appropriate. Let me know if you have any questions.

Jignesh Trivedi · Answer

hi Please refer below link it is good article on database cursor.. http://www.codeproject.com/Tips/277847/How-to-use-Cursor-in-Sql http://www.mssqltips.com/sqlservertip/1599/sql-server-cursor-example/ http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=%2Fcom.ibm.db2.udb.apdv.sql.doc%2Fdoc%2Fc0024361.htm hope this will help you.