Pomelo Lee workspace

Microsoft SQL Server 2008 (RTM) 升级到 Microsoft SQL Server 2008 R2的操作

星期三, 五月 16th, 2012 | Database | 没有评论

Microsoft SQL Server 2008 (RTM) 升级到 Microsoft SQL Server 2008 R2的操作 ，记录x64位系统和32位系统
使用：
select @@VERSION 查询版本号
32位系统显示：
Microsoft SQL Server 2008 (RTM) – 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Developer Edition on Windows NT 6.0 (Build 6001: Service Pack 1)

去下载:SQLFULL_x86_CHS:http://care.dlservice.microsoft.com/dl/download/1/E/6/1E626796-588A-495C-917B-321093FB98EB/2052/SQLFULL_x86_CHS.exe?lcid=2052&ptype=pcare

64位系统显示：
Microsoft SQL Server 2008 (RTM) – 10.0.1600.22 (X64) Jul 9 2008 14:17:44 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)

去下载:SQLFULL_x64_CHS:http://care.dlservice.microsoft.com/dl/download/1/E/6/1E626796-588A-495C-917B-321093FB98EB/2052/SQLFULL_x64_CHS.exe?lcid=2052&ptype=pcare

以升级方式：（序列号在网上找的）
需要输入序列号，必须选这一项：
=========================================
数据中心版：PTTFM-X467G-P7RH2-3Q6CG-4DMYB
DDT3B-8W62X-P9JD6-8MX7M-HWK38
=========================================
企业版：R88PF-GMCFT-KM2KR-4R7GB-43K4B
GYF3T-H2V88-GRPPH-HWRJP-QRTYB
=========================================
标准版：CXTFT-74V4Y-9D48T-2DMFW-TX7CY
B68Q6-KK2R7-89WGB-6Q9KR-QHFDW
=========================================
开发版：MC46H-JQR3C-2JRHY-XYRKY-QWPVM
FTMGC-B2J97-PJ4QG-V84YB-MTXX8
=========================================
工组版：XQ4CB-VK9P3-4WYYH-4HQX3-K2R6Q
=========================================
WEB版：FP4P7-YKG22-WGRVK-MKGMX-V9MTM
=========================================

Tags: Microsoft SQL Server 2008, Microsoft SQL Server 2008 R2, SQLFULL_x64_CHS, SQLFULL_x86_CHS, sqlserver

Sql server 2008 日志满对应的收缩日志的sql

星期日, 三月 21st, 2010 | Database, JAVA-and-J2EE | 没有评论

sql如下：
BACKUP LOG dbname to disk=’dbname.log’
DBCC SHRINKFILE (‘dbname_log’,1)

不过要记得执行两遍才可以最终执行收缩;

Tags: sql, sqlserver, 收缩日志, 日志满

db2, oracle和sqlserver,mysql取前几行的各自独自语法

星期六, 五月 16th, 2009 | Database, JAVA-and-J2EE | 2 Comments

常用的四种数据库的取前几行的sql语句如下： 以前比较不熟悉的是db2，现在天天用，也感觉不错了
db2：
SELECT * ROW_NUMBER() OVER(ORDER BY COL1 DESC) AS ROWNUM WHERE ROWNUM<=10 或者 select * from tab fetch first 10 rows only oracle: select * from tab where rownum <=10 sqlserver: select top 10 * from tab mysql: select * from tab limit 10

Tags: Database, db2, mysql, oracle, sqlserver