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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-17 : 08:03:20
|
| Sevugan writes "Hi, Can you tell me how many types of cursors are there in SQL server 2k. What are they? Give me an example for each of them? When they will be used.Regards,Sevugan.C" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-08-17 : 08:05:04
|
| You can find the types in Books Online under "DECLARE CURSOR", and the best thing you can do in SQL Server is to never use any of them. Use set-based operations and avoid cursors entirely. |
 |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2005-08-17 : 09:50:21
|
What are you talking about Rob? Cursors are VERY useful for those who do not know T-SQL. Help us help YOU!Read this blog entry for more details: http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx*need more coffee*SELECT * FROM Users WHERE CLUE > 0(0 row(s) affected) |
|
|
|
|
|
|
Types of Cursors in SQL Server 2k