How to USe Cursor???????????

Posted by Sabarimahesh under Sql Server on 3/20/2012 | Points: 10 | Views : 3346 | Status : [Member] | Replies : 4

How to USe Cursor...in Sql

Wat is the Use

Life is a Race
Thanks & Regards
By
Sabari Mahesh P M

Reply | Reply with Attachment

Posted by: Sksamantaray on: 3/20/2012 [Member] Silver | Points: 25

0	Hi, Cursor helps you row by row data manipulation in SQL. When you have to apply complex business logic on a specific value of one or more column, writing complex query becomes dificult.It can be achieved using cursor. For more: http://www.mssqltips.com/sqlservertip/1599/sql-server-cursor-example/ http://www.dotnetfunda.com/codes/code91-create-a-simple-cursor-in-sql-server.aspx http://www.dotnetfunda.com/interview/exam296-what-is-cursor-in-sql-server.aspx Thanks, Sanjay Sabarimahesh, if this helps please login to Mark As Answer. \| Alert Moderator

Hi,
Cursor helps you row by row data manipulation in SQL.
When you have to apply complex business logic on a specific value of one or more column, writing complex query becomes dificult.It can be achieved using cursor.
For more:

http://www.mssqltips.com/sqlservertip/1599/sql-server-cursor-example/
http://www.dotnetfunda.com/codes/code91-create-a-simple-cursor-in-sql-server.aspx
http://www.dotnetfunda.com/interview/exam296-what-is-cursor-in-sql-server.aspx

Thanks,
Sanjay

Sabarimahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sabarimahesh on: 3/21/2012 [Member] Bronze | Points: 25

0	Sksamantaray Thanks MAn Life is a Race Thanks & Regards By Sabari Mahesh P M Sabarimahesh, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Patel28rajendra on: 3/21/2012 [Member] Starter | Points: 25

0	Hi visit this link http://msdn.microsoft.com/en-us/library/ms180169.aspx http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=%2Fcom.ibm.db2.udb.apdv.sql.doc%2Fdoc%2Fc0024361.htm http://blog.sqlauthority.com/2007/01/01/sql-server-simple-example-of-cursor/ R D Patel Sabarimahesh, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Sabarimahesh on: 3/22/2012 [Member] Bronze | Points: 25

0	Patel28rajendra Thanks Man ... I'll Work and inform you Dude Life is a Race Thanks & Regards By Sabari Mahesh P M Sabarimahesh, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts