SQL Serverã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’確èªã™ã‚‹æ–¹æ³•
éŽåŽ»ã®è¨˜äº‹ã§ã™ãŒã€æ”¹ã‚ã¦ã€‚
http://d.hatena.ne.jp/matu_tak/20091010/1255167789
SQL Server ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç•ªå·ã¯ã€ŒSELECT @@VERSIONã€ã§ç¢ºèªã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚SQL Server 2008 SP1 CU7 ã¾ã§ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç•ªå·ï¼ˆãƒ“ルド番å·ï¼‰ã‚’ã¾ã¨ã‚ã¾ã—ãŸã€‚
| リリースã€Service Pack | ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç•ªå· | |
| SQL Server 2008 R2 | SQL Server 2008 R2 CTP2 | 10.50.1092 |
| SQL Server 2008 R2 CTP3 | 10.50.1352 | |
| SQL Server 2008 R2 RTM | 10.50.1600 | |
| SQL Server 2008 R2 RTM CU1 | 10.50.1702 | |
| SQL Server 2008 R2 RTM CU2 | 10.50.1720 | |
| SQL Server 2008 R2 RTM CU3 | 10.50.1734 | |
| SQL Server 2008 R2 RTM CU4 | 10.50.1746 | |
| SQL Server 2008 R2 RTM CU5 | 10.50.1753 | |
| SQL Server 2008 | SQL Server 2008 RTM | 10.0.1600 |
| SQL Server 2008 Service Pack 1 (SP1) | 10.0.2531 | |
| SQL Server 2008 Service Pack 1 (SP1) CU1 | 10.0.2710 | |
| SQL Server 2008 Service Pack 1 (SP1) CU2 | 10.0.2714 | |
| SQL Server 2008 Service Pack 1 (SP1) CU3 | 10.0.2723 | |
| SQL Server 2008 Service Pack 1 (SP1) CU4 | 10.0.2734 | |
| SQL Server 2008 Service Pack 1 (SP1) CU5 | 10.0.2746 | |
| SQL Server 2008 Service Pack 1 (SP1) CU6 | 10.0.2757 | |
| SQL Server 2008 Service Pack 1 (SP1) CU7 | 10.0.2766 | |
| SQL Server 2008 Service Pack 1 (SP1) CU8 | 10.0.2775 | |
| SQL Server 2008 Service Pack 1 (SP1) CU9 | 10.0.2789 | |
| SQL Server 2008 Service Pack 2 (SP2) | 10.0.4000 | |
| SQL Server 2008 Service Pack 2 (SP2) CU1 | 10.0.4266 | |
| SQL Server 2005 | SQL Server 2005 RTM | 9.00.1399 |
| SQL Server 2005 Service Pack 1 (SP1) | 9.00.2047 | |
| SQL Server 2005 Service Pack 2 (SP2) | 9.00.3042 | |
| SQL Server 2005 Service Pack 3 (SP3) | 9.00.4035 | |
| SQL Server 2005 Service Pack 3 (SP3) CU12 | 9.00.4311 | |
| SQL Server 2005 Service Pack 4 (SP4) | 9.00.5000 | |
| SQL Server 2005 Service Pack 4 (SP4) CU1 | 9.00.5254 | |
| SQL Server 2000 | SQL Server 2000 RTM | 8.00.194 |
| SQL Server 2000 Service Pack 1 (SP1) | 8.00.384 | |
| SQL Server 2000 Service Pack 2 (SP2) | 8.00.534 | |
| SQL Server 2000 Service Pack 3 (SP3) | 8.00.760 | |
| SQL Server 2000 Service Pack 3a (SP3a) | 8.00.760 | |
| SQL Server 2000 Service Pack 4 (SP4) | 8.00.2039 | |
| SQL Server 7.0 | SQL Server 7.0 RTM | 7.00.623 |
| SQL Server 7.0 Service Pack 1 (SP1) | 7.00.699 | |
| SQL Server 7.0 Service Pack 2 (SP2) | 7.00.842 | |
| SQL Server 7.0 Service Pack 3 (SP3) | 7.00.961 | |
| SQL Server 7.0 Service Pack 4 (SP4) | 7.00.1063 | |
| SQL Server 6.5 | SQL Server 6.5 RTM | 6.50.201 |
| SQL Server 6.5 Service Pack 1 (SP1) | 6.50.213 | |
| SQL Server 6.5 Service Pack 2 (SP2) | 6.50.240 | |
| SQL Server 6.5 Service Pack 3 (SP3) | 6.50.258 | |
| SQL Server 6.5 Service Pack 4 (SP4) | 6.50.281 | |
| SQL Server 6.5 Service Pack 5 (SP5) | 6.50.415 | |
| SQL Server 6.5 Service Pack 5a (SP5a) | 6.50.416 | |
| SQL Server 6.5 Service Pack 5a (SP5a) Update | 6.50.479 |
＜å‚考記事＞
How to identify your SQL Server version and edition
http://support.microsoft.com/kb/321185/en-us
Dahlog： SQL Server versions
http://nida.se/dahlog/?p=142
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- -
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
2010/01/27 追記
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- -
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
ã“ã®è¨˜äº‹ã®æ›´æ–°ã¯åœæ¢ã—ã¦ï¼ˆæœ€æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¸ã®å¯¾å¿œã¯åœæ¢ã—ã¦ï¼‰ã€æ›´æ–°ç‰ˆã¯ã€ã“ã¡ã‚‰ã¸ã¾ã¨ã‚ã¦ã„ã¾ã™ã€‚
http://www.sqljump.com/tech/sql/sql20101208.aspx
