Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
raj.prabhu001
Starting Member
16 Posts |
Posted - 2011-08-16 : 06:39:33
|
hii i am new to sql server programmingcan any1 plz demonstrate a simple cursor to process each row and add some simple computation so that i can understand how it works.PLZ USE Adventure works database.Thanks in advance |
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-08-16 : 07:07:20
|
There is a discussion and some examples using Adventureworks on this MSDN page: http://msdn.microsoft.com/en-us/library/ms190028(v=sql.90).aspx |
|
|
raj.prabhu001
Starting Member
16 Posts |
Posted - 2011-08-16 : 08:21:07
|
but there is none example out dere can u gv some example here |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-08-16 : 09:09:07
|
How about this? (I am trying to get out of having to write an example myself )http://blog.sqlauthority.com/2008/03/05/sql-server-simple-example-of-cursor-sample-cursor-part-2/ |
|
|
|
|
|