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

Posted by Sabarimahesh under Sql Server on 3/20/2012 | Points: 10 | Views : 2290 | 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



Responses

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

Up
0
Down

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

Up
0
Down
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: Sabarimahesh on: 3/22/2012 [Member] Bronze | Points: 25

Up
0
Down
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

Login to post response