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: ......
CREATE proc page
@RecordCount int output,
@QueryStr nvarchar(100)='table1',--表名、视图名、查询语句
@PageSize int=20, --每页的大小(行数)
@PageCurrent int=2, --要显示的页 从0开始
@FdShow nvarchar (1000)='*', --要显示的字段列表
@IdentityStr nvarchar (100)='id', --主键
@WhereStr nvarchar ......
可以筛选数据，但不能是标准的SQL语句：
Me.DsUserManager1.Tables(0).Select("id > 5 and id <20")
---------------------------------------------------------------
1.筛选：
dataset.tables("tabname").select("id=1")'相当于SQL中WHERE后的条件内容
2.保存到哪？这倒是不知 ......
字符类型：
CHAR(size)：固定长度字符串，最大长度2000 bytes
VARCHAR2(size)：可变长度的字符串，最大长度4000 bytes，可做索引的最大长度749
NCHAR(size)：根据字符集而定的固定长度字符串，最大长度2000 bytes
NVARCHAR2(size)：根据字符集而定的可变长度字符串，最大长度4000 byte
LONG：变长的字符串，最大长度限 ......
--------------------------------查询系统库中是否有库（有库就删除此库）----------------------------------------------------
use master
if exists(select * from databases where name='库名')
drop database 库名
__________________________ 建数据库建表的基本格式 __________________ ......
