{"id":2414,"date":"2013-01-18T04:16:48","date_gmt":"2013-01-18T04:16:48","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=2414"},"modified":"2013-11-05T02:12:04","modified_gmt":"2013-11-05T02:12:04","slug":"sql%e7%89%88%e6%9c%ac","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2013\/01\/18\/sql%e7%89%88%e6%9c%ac\/","title":{"rendered":"sql\u7248\u672c"},"content":{"rendered":"
\r\nSELECT  DATABASEPROPERTYEX('mydb','version'),SERVERPROPERTY('Edition') [\u5df2\u5b89\u88c5\u4ea7\u54c1\u7248\u672c], SERVERPROPERTY('ProductLevel') [SQL Server \u5b9e\u4f8b\u7684\u7248\u672c\u7ea7\u522b],SERVERPROPERTY('ProductVersion') [SQL Server \u5b9e\u4f8b\u7684\u7248\u672c]\r\n\r\n\r\n<\/pre>\n
\n\n\n\n\n\n\n\n\n\n
\n
\n\t\t\t\t\t\tQL Server Version<\/strong><\/div>\n<\/td>\n
\n\t\t\t\t\t<\/p>\n
\n\t\t\t\t\t\tInternal Database Version<\/strong><\/div>\n<\/td>\n<\/tr>\n
\n\t\t\t\t\t<\/p>\n
\n\t\t\t\t\t\tSQL Server 2008 R2<\/div>\n<\/td>\n
\n\t\t\t\t\t<\/p>\n
\n\t\t\t\t\t\t665<\/div>\n<\/td>\n<\/tr>\n
\n\t\t\t\t\t<\/p>\n
\n\t\t\t\t\t\tSQL Server 2008<\/div>\n<\/td>\n
\n\t\t\t\t\t<\/p>\n
\n\t\t\t\t\t\t661<\/div>\n<\/td>\n<\/tr>\n
\n\t\t\t\t\t<\/p>\n
\n\t\t\t\t\t\tSQL Server 2005 SP2+ with vardecimal enabled<\/div>\n<\/td>\n
\n\t\t\t\t\t<\/p>\n
\n\t\t\t\t\t\t612<\/div>\n<\/td>\n<\/tr>\n
\n\t\t\t\t\t<\/p>\n
\n\t\t\t\t\t\tSQL Server 2005<\/div>\n<\/td>\n
\n\t\t\t\t\t<\/p>\n
\n\t\t\t\t\t\t611<\/div>\n<\/td>\n<\/tr>\n
\n\t\t\t\t\t<\/p>\n
\n\t\t\t\t\t\tSQL Server 2000<\/div>\n<\/td>\n
\n\t\t\t\t\t<\/p>\n
\n\t\t\t\t\t\t539<\/div>\n<\/td>\n<\/tr>\n
\n\t\t\t\t\t<\/p>\n
\n\t\t\t\t\t\tSQL Server 7<\/div>\n<\/td>\n
\n\t\t\t\t\t<\/p>\n
\n\t\t\t\t\t\t515<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
\n\tRelease<\/div>\n
\n\tProduct Version<\/div>\n
\n\tSQL Server 2012 Service Pack 1 <\/span>11.00.3000.00<\/div>\n
\n\tSQL Server 2012 RTM <\/span>11.00.2100.60<\/div>\n
\n\tSQL Server 2008 R2 Versions<\/div>\n
\n\tRelease <\/span>Product Version<\/div>\n
\n\tSQL Server 2008 R2 Service Pack 1 <\/span>10.50.2500.0<\/div>\n
\n\tSQL Server 2008 R2 RTM <\/span>10.50.1600.1<\/div>\n
\n\tSQL Server 2008 Versions<\/div>\n
\n\tRelease <\/span>Product Version<\/div>\n
\n\tSQL Server 2008 Service Pack 3 <\/span>10.00.5500.00<\/div>\n
\n\tSQL Server 2008 Service Pack 2 <\/span>10.00.4000.00<\/div>\n
\n\tSQL Server 2008 Service Pack 1 <\/span>10.00.2531.00<\/div>\n
\n\tSQL Server 2008 RTM <\/span>10.00.1600.22<\/div>\n
\n\tSQL Server 2005 Versions<\/div>\n
\n\tRelease <\/span>Product version<\/div>\n
\n\tSQL Server 2005 Service Pack 4 <\/span>9.00.5000.00<\/div>\n
\n\tSQL Server 2005 Service Pack 3 <\/span>9.00.4035<\/div>\n
\n\tSQL Server 2005 Service Pack 2 <\/span>9.00.3042<\/div>\n
\n\tSQL Server 2005 Service Pack 1 <\/span>9.00.2047<\/div>\n
\n\tSQL Server 2005 RTM <\/span>9.00.1399<\/div>\n
\n\tSQL Server 2000 Versions<\/div>\n
\n\tRelease <\/span>Product version<\/div>\n
\n\tSQL Server 2000 Service Pack 4 <\/span>8.00.2039<\/div>\n
\n\tSQL Server 2000 Service Pack 3 <\/span>8.00.760<\/div>\n
\n\tSQL Server 2000 Service Pack 3 <\/span>8.00.760<\/div>\n
\n\tSQL Server 2000 Service Pack 2 <\/span>8.00.534<\/div>\n
\n\tSQL Server 2000 Service Pack 1 <\/span>8.00.384<\/div>\n
\n\tSQL Server 2000 RTM <\/span>8.00.194<\/div>\n
\n\t <\/div>\n","protected":false},"excerpt":{"rendered":"
SELECT  DATABASEPROPERTYEX('mydb','ver […]<\/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-2414","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\/2414","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=2414"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2414\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=2414"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=2414"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=2414"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}