{"id":63,"date":"2006-06-16T15:38:30","date_gmt":"2006-06-16T15:38:30","guid":{"rendered":"http:\/\/blog.jason695.idv.tw:81\/wordpress\/?p=63"},"modified":"2006-06-16T15:50:23","modified_gmt":"2006-06-16T15:50:23","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","status":"publish","type":"post","link":"https:\/\/jason695.why3s.tw\/wordpress\/2006\/06\/16\/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\/","title":{"rendered":"VS2005\u958b\u767cSQL Server2005\u8cc7\u6599\u5eab\u7269\u4ef6\u8207\u6574\u5408T-SQL\u589e\u529f\u80fd"},"content":{"rendered":"

5\/28
\n\u5149\u6253\u7814\u8a0e\u6703\u7684\u540d\u5b57\u5c31\u89ba\u5f97\u5f88\u9577……………
\nSQL2005\u529f\u80fd\u589e\u52a0\u4e86\u8a31\u591a,\u4e0d\u904e…\u6211\u597d\u50cf\u90fd\u7528\u4e0d\u592a\u5230….<\/p>\n

    \n
  1. \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,
    \n\u5982\uff1a\u6709\u8cc7\u6599\u6642UPDATE,\u7121\u8cc7\u6599\u6642INSERT,
    \n\u5c31\u53ef\u4ee5\u6539\u7531SQL\u4f86\u8655\u7406(\u52a0\u5728CommandText\u88e1)<\/li>\n
  2. 2005\u7684Stored Procedures(\u9810\u5b58\u7a0b\u5e8f)\u5df2\u80fd\u548c\u65b0\u7248\u7684Oracle\u7d50\u5408<\/li>\n
  3. Cursor(\u8cc7\u6599\u6307\u6a19),\u96d6\u7136\u96e3\u5beb,\u4f46\u662f\u6279\u6b21\u5927\u91cf\u8655\u7406\u6642,\u4ecd\u5f88\u91cd\u8981<\/li>\n
  4. \u597d\u7684\u8001\u5e2b\u5e36\u4f60\u4e0a\u5929\u5802<\/span>,\u4e0d\u597d\u7684\u8001\u5e2b\u8b93\u4f60\u4f4f\u6a5f\u623f<\/span><\/li>\n
  5. \u694a\u8001\u5e2b\u65b0\u66f8\u9810\u5148\u767c\u8868\u6703(\u56e0\u70ba\u624d\u525b\u9001\u5370\u800c\u5df2)<\/li>\n
  6. \u8001\u5e2b\u66f8\u88e1\u7684\u7a0b\u5f0f\u4e00\u5b9a\u80fd\u57f7\u884c…..<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    5\/28 \u5149\u6253\u7814\u8a0e\u6703\u7684\u540d\u5b57\u5c31\u89ba\u5f97\u5f88\u9577…………… S … \u95b1\u8b80\u5168\u6587 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":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[12],"tags":[],"class_list":["post-63","post","type-post","status-publish","format-standard","hentry","category-12","no-featured-image"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/63","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=63"}],"version-history":[{"count":0,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/63\/revisions"}],"wp:attachment":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/media?parent=63"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/categories?post=63"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/tags?post=63"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}