{"id":1856,"date":"2011-07-18T12:14:56","date_gmt":"2011-07-18T04:14:56","guid":{"rendered":"http:\/\/jason695.why3s.tw\/wordpress\/?p=1856"},"modified":"2011-09-06T15:32:06","modified_gmt":"2011-09-06T07:32:06","slug":"sql-server-cursor-%e7%b0%a1%e5%96%ae%e7%af%84%e4%be%8b","status":"publish","type":"post","link":"https:\/\/jason695.why3s.tw\/wordpress\/2011\/07\/18\/sql-server-cursor-%e7%b0%a1%e5%96%ae%e7%af%84%e4%be%8b\/","title":{"rendered":"[\u8f49\u8cbc]SQL SERVER–cursor \u7c21\u55ae\u7bc4\u4f8b"},"content":{"rendered":"

http:\/\/pgtalk.blogspot.com\/2007\/11\/sql-server-cursor.html<\/a><\/p>\n


\nUSE [testDB]
\nGO
\n\/****** \u7269\u4ef6: StoredProcedure [dbo].[pavo_CalculateRecordSum] \u6307\u4ee4\u78bc\u65e5\u671f: 11\/15\/2007 11:55:51 ******\/
\nSET ANSI_NULLS ON
\nGO
\nSET QUOTED_IDENTIFIER ON
\nGO<\/code><\/p>\n

CREATE PROCEDURE [dbo].[sp_cursor_Test]
\nAS
\nBEGIN
\nBEGIN TRY
\nBEGIN TRANSACTION
\nSET NOCOUNT ON;
\nDECLARE Cur Cursor FOR
\nSELECT a,b,c
\nFROM Table_A
\n–\u958b\u555fcursor
\nOpen Cur<\/p>\n

–\u5b9a\u7fa9cursor\u88e1\u8981\u53d6\u51fa\u7684\u7269\u4ef6
\nDECLARE @a int,@b nvarchar(50), @c DATETIME<\/p>\n

–\u9032\u5165cursor
\nFetch NEXT FROM Cur INTO @a, @b,@c
\nprint @@FETCH_STATUS;
\nWhile (@@FETCH_STATUS <> -1)
\nBEGIN
\n–\u5728\u6b64\u52a0\u5165LOOP\u4e2d\u7684\u5167\u5bb9<\/p>\n

————————<\/p>\n

–\u518d\u5230\u4e0b\u500b\u6307\u6a19\u53bb
\nFetch NEXT FROM Cur INTO @a, @b,@c
\nEND<\/p>\n

–\u95dc\u9589cursor
\nCLOSE Cur
\n–\u91cb\u653ecursor
\nDEALLOCATE Cur<\/p>\n

COMMIT TRANSACTION;
\nEND TRY
\nBEGIN CATCH
\n–\u5370\u51fa\u932f\u8aa4\u8a0a\u606f
\nPRINT ERROR_NUMBER();
\nPRINT ERROR_MESSAGE();
\nROLLBACK TRANSACTION;
\n–\u95dc\u9589cursor
\nCLOSE Cur
\n–\u91cb\u653ecursor
\nDEALLOCATE Cur
\nEND CATCH;
\nEND<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

http:\/\/pgtalk.blogspot.com\/2007\/11\/sql-server-cursor.ht … \u95b1\u8b80\u5168\u6587 [\u8f49\u8cbc]SQL SERVER–cursor \u7c21\u55ae\u7bc4\u4f8b<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[47],"tags":[],"class_list":["post-1856","post","type-post","status-publish","format-standard","hentry","category-sql-server","no-featured-image"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/1856","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/comments?post=1856"}],"version-history":[{"count":0,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/1856\/revisions"}],"wp:attachment":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/media?parent=1856"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/categories?post=1856"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/tags?post=1856"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}