{"id":2377,"date":"2012-12-28T07:37:40","date_gmt":"2012-12-28T07:37:40","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=2377"},"modified":"2012-12-28T07:37:40","modified_gmt":"2012-12-28T07:37:40","slug":"%e8%ae%be%e8%ae%a1%e5%99%a8overkill","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2012\/12\/28\/%e8%ae%be%e8%ae%a1%e5%99%a8overkill\/","title":{"rendered":"\u8bbe\u8ba1\u5668overkill"},"content":{"rendered":"<p>\u5728\u589e\u52a0\u4e3b\u952e\u6216\u8bbe\u7f6e\u9ed8\u8ba4\u503c\u65f6\uff0c\u82e5\u7528\u8bbe\u8ba1\u5668\uff0c\u5219\u4f1a\u91cd\u5efa\u8868\uff0c\u907f\u514d\u65b9\u6cd5\u5c31\u662f\u7528t-sql<\/p>\n<pre class=\"brush:sql;first-line:1;pad-line-numbers:true;highlight:null;collapse:false;\">\r\nALTER TABLE dbo.TestInt ADD CONSTRAINT\r\n    DF_TestInt_Col1 DEFAULT 1 FOR Col1\r\n\r\n\r\n<\/pre>\n<div>\n<pre class=\"brush:sql;first-line:1;pad-line-numbers:true;highlight:null;collapse:false;\">\r\nALTER TABLE dbo.TestInt ADD CONSTRAINT<\/pre>\n<\/div>\n<div>\n\t&nbsp; &nbsp; PK_TestInt PRIMARY KEY CLUSTERED<\/div>\n<div>\n\t&nbsp; &nbsp; (Col1) &nbsp;ON [PRIMARY]<\/div>\n<p>\u53c2\u8003\uff1a<a href=\"http:\/\/blogs.lessthandot.com\/index.php\/DataMgmt\/DBAdmin\/MSSQLServerAdmin\/do-not-trust-the-ssms\">Do not trust the SSMS designers<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5728\u589e\u52a0\u4e3b\u952e\u6216\u8bbe\u7f6e\u9ed8\u8ba4\u503c\u65f6\uff0c\u82e5\u7528\u8bbe\u8ba1\u5668\uff0c\u5219\u4f1a\u91cd\u5efa\u8868\uff0c\u907f\u514d\u65b9\u6cd5\u5c31\u662f\u7528t-sql ALTER TABLE dbo.T [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-2377","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2377","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/comments?post=2377"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2377\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=2377"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=2377"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=2377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}