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 |
|
khalik
Constraint Violating Yak Guru
443 Posts |
 Posted - 2002-02-05 : 04:45:35
|
| hi i read we have something row based and set based.... related to cursors.... i am not sure where can we use it and how to use it...regards======================================Ask to your self before u ask someone |
|
|
dsdeming
479 Posts |
Posted - 2002-02-05 : 08:24:22
|
| Cursors are row-based by definition. A cursor deals with one row at a time. FETCH NEXT is the SQL functional equivalent of the NEXT in a FOR NEXT loop.SQL data manipulation language ( select, insert, update, delete ) is set-based. The WHERE clause determines the rows to be acted upon. While a where clause may limit the activity to a set composed of a single row, in most cases multiple rows are manipulated at once.Hope this helps. |
 |
|
|
|
|
|
cursors..... row based and set based