{"id":2293,"date":"2013-02-06T19:50:57","date_gmt":"2013-02-06T11:50:57","guid":{"rendered":"http:\/\/jason695.why3s.tw\/wordpress\/?p=2293"},"modified":"2013-02-16T23:36:59","modified_gmt":"2013-02-16T15:36:59","slug":"%e5%bf%ab%e9%80%9f%e5%8f%96%e5%be%97%e8%b3%87%e6%96%99%e5%ba%ab%e8%b3%87%e6%96%99%e8%a1%a8%e7%b5%90%e6%a7%8b","status":"publish","type":"post","link":"https:\/\/jason695.why3s.tw\/wordpress\/2013\/02\/06\/%e5%bf%ab%e9%80%9f%e5%8f%96%e5%be%97%e8%b3%87%e6%96%99%e5%ba%ab%e8%b3%87%e6%96%99%e8%a1%a8%e7%b5%90%e6%a7%8b\/","title":{"rendered":"\u5feb\u901f\u53d6\u5f97\u8cc7\u6599\u5eab\u8cc7\u6599\u8868\u7d50\u69cb"},"content":{"rendered":"<pre class=\"lang:tsql decode:true crayon-selected\">select t.name as [table name], c.name AS [column name], tp.name AS [\u8cc7\u6599\u578b\u5225],\r\n  case tp.name\r\n  when 'bigint' then cast(c.precision as varchar(3))\r\n  when 'int' then cast(c.precision as varchar(3))\r\n  when 'smallint' then cast(c.precision as varchar(3))\r\n  when 'tinyint' then cast(c.precision as varchar(3))\r\n  when 'numeric' then '(' + cast(c.precision as varchar(3)) + ',' + cast(c.scale as varchar(3)) + ')'\r\n\u00a0 when 'decimal' then '(' + cast(c.precision as varchar(3)) + ',' + cast(c.scale as varchar(3)) + ')'\r\n  when 'nvarchar' then cast((c.max_length\/2) as varchar(5))\r\n  when 'nchar' then cast((c.max_length\/2) as varchar(5))\r\n  else cast(c.max_length as varchar(5))\r\n  end as [\u9577\u5ea6],\r\n  CASE WHEN c.is_nullable=1 THEN 'ok' ELSE 'no' END AS [NULL ok],\r\n  ep.value as [\u63cf\u8ff0] \r\nfrom sys.tables as t\r\ninner join sys.columns as c on t.object_id=c.object_id\r\ninner join sys.types as tp on c.system_type_id = tp.system_type_id\r\nleft outer join sys.extended_properties as ep on (ep.major_id = t.object_id\r\nand ep.minor_id = c.column_id and ep.class = 1 )\r\nwhere tp.system_type_id = tp.user_type_id \r\norder by t.name,c.name<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>select t.name as [table name], c.name AS [column name], &hellip; <a href=\"https:\/\/jason695.why3s.tw\/wordpress\/2013\/02\/06\/%e5%bf%ab%e9%80%9f%e5%8f%96%e5%be%97%e8%b3%87%e6%96%99%e5%ba%ab%e8%b3%87%e6%96%99%e8%a1%a8%e7%b5%90%e6%a7%8b\/\" class=\"more-link\">\u95b1\u8b80\u5168\u6587 <span class=\"screen-reader-text\">\u5feb\u901f\u53d6\u5f97\u8cc7\u6599\u5eab\u8cc7\u6599\u8868\u7d50\u69cb<\/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-2293","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\/2293","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=2293"}],"version-history":[{"count":0,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/2293\/revisions"}],"wp:attachment":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/media?parent=2293"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/categories?post=2293"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/tags?post=2293"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}