{"id":1441,"date":"2006-05-29T11:41:17","date_gmt":"2006-05-29T03:41:17","guid":{"rendered":"http:\/\/jason6956.wordpress.com\/2006\/05\/29\/vs2005%e9%96%8b%e7%99%bcsql-server2005%e8%b3%87%e6%96%99%e5%ba%ab%e7%89%a9%e4%bb%b6%e8%88%87%e6%95%b4%e5%90%88t-sql%e5%a2%9e%e5%8a%9f%e8%83%bd"},"modified":"2010-10-06T21:09:50","modified_gmt":"2010-10-06T13:09:50","slug":"vs2005%e9%96%8b%e7%99%bcsql-server2005%e8%b3%87%e6%96%99%e5%ba%ab%e7%89%a9%e4%bb%b6%e8%88%87%e6%95%b4%e5%90%88t-sql%e5%a2%9e%e5%8a%9f%e8%83%bd-2","status":"publish","type":"post","link":"https:\/\/jason695.why3s.tw\/wordpress\/2006\/05\/29\/vs2005%e9%96%8b%e7%99%bcsql-server2005%e8%b3%87%e6%96%99%e5%ba%ab%e7%89%a9%e4%bb%b6%e8%88%87%e6%95%b4%e5%90%88t-sql%e5%a2%9e%e5%8a%9f%e8%83%bd-2\/","title":{"rendered":"VS2005\u958b\u767cSQL Server2005\u8cc7\u6599\u5eab\u7269\u4ef6\u8207\u6574\u5408T-SQL\u589e\u529f\u80fd"},"content":{"rendered":"<div id=\"msgcns!1BF4A629EA6C6E8E!2773\" class=\"bvMsg\">5\/28<br \/>\u5149\u6253\u7814\u8a0e\u6703\u7684\u540d\u5b57\u5c31\u89ba\u5f97\u5f88\u9577&#8230;&#8230;&#8230;&#8230;&#8230;<img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/spaces.msn.com\/rte\/emoticons\/smile_sick.gif?w=712\" \/><br \/>SQL2005\u529f\u80fd\u589e\u52a0\u4e86\u8a31\u591a,\u4e0d\u904e&#8230;\u6211\u597d\u50cf\u90fd\u7528\u4e0d\u592a\u5230&#8230;.<\/p>\n<ol>\n<li>\u5728SQL2005\u4e2d,\u53ef\u4ee5\u7528VS2005\u4f86\u5beb\u7d44\u4ef6(\u591a\u4e86CLE\u9019\u500b\u968e\u6bb5),\u4e5f\u5c31\u662f\u5beb\u5728\u524d\u7aef\u7684\u5224\u65b7,<br \/>\u5982\uff1a\u6709\u8cc7\u6599\u6642UPDATE,\u7121\u8cc7\u6599\u6642INSERT,<br \/>\u5c31\u53ef\u4ee5\u6539\u7531SQL\u4f86\u8655\u7406(\u52a0\u5728CommandText\u88e1)<\/li>\n<li>2005\u7684Stored Procedures(\u9810\u5b58\u7a0b\u5e8f)\u5df2\u80fd\u548c\u65b0\u7248\u7684Oracle\u7d50\u5408<\/li>\n<li>Cursor(\u8cc7\u6599\u6307\u6a19),\u96d6\u7136\u96e3\u5beb,\u4f46\u662f\u6279\u6b21\u5927\u91cf\u8655\u7406\u6642,\u4ecd\u5f88\u91cd\u8981<\/li>\n<li>\u597d\u7684\u8001\u5e2b\u5e36\u4f60\u4e0a<span style=\"font-weight:bold;\">\u5929\u5802<\/span>,\u4e0d\u597d\u7684\u8001\u5e2b\u8b93\u4f60\u4f4f<span style=\"font-weight:bold;\">\u6a5f\u623f<\/span><\/li>\n<li>\u694a\u8001\u5e2b\u65b0\u66f8\u9810\u5148\u767c\u8868\u6703(\u56e0\u70ba\u624d\u525b\u9001\u5370\u800c\u5df2)<\/li>\n<li>\u8001\u5e2b\u66f8\u88e1\u7684\u7a0b\u5f0f\u4e00\u5b9a\u80fd\u57f7\u884c&#8230;..<\/li>\n<\/ol>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>5\/28\u5149\u6253\u7814\u8a0e\u6703\u7684\u540d\u5b57\u5c31\u89ba\u5f97\u5f88\u9577&#8230;&#8230;&#8230;&#8230;&#8230;SQL &hellip; <a href=\"https:\/\/jason695.why3s.tw\/wordpress\/2006\/05\/29\/vs2005%e9%96%8b%e7%99%bcsql-server2005%e8%b3%87%e6%96%99%e5%ba%ab%e7%89%a9%e4%bb%b6%e8%88%87%e6%95%b4%e5%90%88t-sql%e5%a2%9e%e5%8a%9f%e8%83%bd-2\/\" class=\"more-link\">\u95b1\u8b80\u5168\u6587 <span class=\"screen-reader-text\">VS2005\u958b\u767cSQL Server2005\u8cc7\u6599\u5eab\u7269\u4ef6\u8207\u6574\u5408T-SQL\u589e\u529f\u80fd<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[29],"tags":[],"class_list":["post-1441","post","type-post","status-publish","format-standard","hentry","category-29","no-featured-image"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/1441","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=1441"}],"version-history":[{"count":0,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/1441\/revisions"}],"wp:attachment":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/media?parent=1441"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/categories?post=1441"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/tags?post=1441"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}