SQL 版本和补丁
I'm continually trying to track down what service packs are installed on various SQL Servers I support. I can never find the right support page on Microsoft's site. So here's an article with all the SQL Server version information I can track down. If you know of any older versions or can help me fill out any missing data, please post in the comments and I'll update the article.
The versions of SQL Server are listed in the following table. Below the table are instructions to determine what build you are running.
SQL Server 2008
10.00.27.57
SQL Server 2008 SP1 CU6
18 Jan 2010
10.00.2746
SQL Server 2008 SP1 CU5
24 Nov 2009
10.00.2734
SQL Server 2008 SP1 CU4
22 Sept 2009
10.00.2723
SQL Server 2008 SP1 CU3
21 July 2009
10.00.2714
SQL Server 2008 SP1 CU2
18 May 2009
10.00.2710
SQL Server 2008 SP1 CU1
16 Apr 2009
10.00.2531
SQL Server 2008 SP1
7 Apr 2009
10.00.1828
SQL Server 2008 RTM CU9
18 Jan 2009
10.00.1823
SQL Server 2008 RTM CU8
16 Nov 2009
10.00.1818
SQL Server 2008 RTM CU7
21 Sept 2009
10.00.1812
SQL Server 2008 RTM CU6
21 July 2009
10.00.1806
SQL Server 2008 RTM CU5
18 May 2009
10.00.1798
SQL Server 2008 RTM CU4
17 Mar 2009
10.00.1787
SQL Server 2008 RTM CU3
19 Jan 2009
10.00.1779
SQL Server 2008 RTM CU2
17 Nov 2008
10.00.1763
SQL Server 2008 RTM CU1
22 Sept 2008
10.00.1600
SQL Server 2008 RTM
6 Aug 2008
SQL Server 2005
9.00.4273
SQL Server 2005 SP3 CU7
21 Dec 2009
9.00.4266
SQL Server 2005 SP3 CU6
19 Oct 2009
9.00.4230
SQL Server 2005 SP3 CU5
17 Aug 2009
9.00.4226
SQL Server 2005 SP3 CU4
16 June 2009
9.00.4220
SQL Server 2005 SP3 CU3
21 Apr 2009
9.00.4211
SQL Server 2005 SP3 CU2
17 Feb 2009
9.00.4207
SQL Server 2005 SP3 CU1
20 Dec 2008
9.00.4035
SQL Server 2005 SP3
16 Dec 2008
9.00.3356
SQL Server 2005 SP2 CU17
21 Dec 2009
9.00.3355
SQL Server 2005 SP2 CU16
19 Oct 2009
9.00.3330
SQL Server 2005 SP2 CU15
18 Aug 2009
9.00.3328
SQL Server 2005 SP2 CU14
16 June 2009
9.00.3225
相关文档：
如果按照powerdesigner的默认选项,生成的sql不能在mysql中正确运行.]
经过本人研究发现要做如下修改:
1.aftercreate选项改为
.foreach_item(OutReferences)
.ifnot (%hasFKIndex%)
/*==============================================================*/
/* Index: ......
Oracle
SQL
的优化规
则：
尽量少用IN操作符，基本上所有的IN操作符都可以用EXISTS代替
用IN写出来的SQL
的优点是比较容易写及清晰易懂，但是用IN的SQL
性能总是比较低的，从ORACLE
执
行的步骤来分析用IN的SQL
与不用IN的SQL
有
以下区别：
......
Sql常用语法下列语句部分是Mssql语句，不可以在access中使用。
SQL分类：
DDL—数据定义语言(CREATE，ALTER，DROP，DECLARE)
DML—数据操纵语言(SELECT，DELETE，UPDATE，INSERT)
DCL—数据控制语言(GRANT，REVOKE，COMMIT，ROLLBACK) 首先,简要介绍基础语句：
1、说明：创建数据库
CREATE ......
http://tech.163.com/05/0701/10/1NIODMQS00091589.html
因为在PL/SQL 中并没有数组.
这是偶查资料找的范例和自己写的范例来解释如何在PL/SQL 中使用数组. 也许很多人已知道, 不过就是让不知道的朋友们了解一下吧。
----------------------
单维数组
------------------------
DECLARE
TYPE
emp_ssn_array IS TA ......
