How to use cursor in sqlserver step by step procedure

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.

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.