SQL Server 游标参考(语法等) [英] SQL Server Cursor Reference (Syntax, etc)

问题描述

我不经常使用 SQL Server 游标，但是当我使用时，我总是要查找语法和选项.

I don't use SQL Server Cursors often but when I do, I always have to look up the syntax and options.

所以我想问一下，网络上最好的 SQL Server Cursor 参考是什么?

So I wanted to ask, what is the best SQL Server Cursor reference on the web?.

我正在寻找解释所有(主要?)选项(I.E. FAST_FORWARD)的参考资料，并显示如何使用它的快速片段.(即如何通过游标实现循环以及检查@@FETCH_STATUS 变量的良好做法.)

I'm looking for a reference that explains all of the (major?) options (I.E. FAST_FORWARD) and also shows quick snippets of how to use it. (I.E. How to implement looping though a cursor and with a good practice for checking the @@FETCH_STATUS variable.)

最好的问候，
弗兰克

Best Regards,
Frank

快速更新:我正在寻找快速参考但足够详细以查看我的选项的平衡.举个例子.MSDN 是一个很好的参考指南，但它有太多的细节.理想情况下，参考资料应该简洁.

Quick Update: I'm looking for a balance of quick-reference but detailed enough to see my options. As an example. MSDN is a great reference guide but it has too much detail. The reference, ideally, should be concise.

进一步更新:我仍在寻找资源.如果有人发布了符合我简洁标准的好资源，我会接受这个答案...

Further update: I'm still looking for sources. If someone posts a good source that fits my criteria of concise, I will accept that answer...

推荐答案

我会从 MSDN 的光标帮助页面开始...

I'd start out with the MSDN help page for cursors...

http://msdn.microsoft.com/en-us/library/ms180169.aspx

这篇关于SQL Server 游标参考(语法等)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！