sqlserver
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
去下载: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
去下载: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
=========================================
Sql server 2008 日志满对应的收缩日志的sql
星期日, 三月 21st, 2010 | Database, JAVA-and-J2EE | 没有评论
sql如下:
BACKUP LOG dbname to disk=’dbname.log’
DBCC SHRINKFILE (‘dbname_log’,1)
不过要记得执行两遍才可以最终执行收缩;
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
Search
相关文章
热门文章
最新文章
文章分类
- ajax (10)
- algorithm-learn (3)
- Android (6)
- as (3)
- computer (85)
- Database (30)
- disucz (4)
- enterprise (1)
- erlang (2)
- flash (5)
- golang (3)
- html5 (18)
- ios (4)
- JAVA-and-J2EE (186)
- linux (143)
- mac (10)
- movie-music (11)
- pagemaker (36)
- php (50)
- spring-boot (2)
- Synology群晖 (2)
- Uncategorized (6)
- unity (1)
- webgame (15)
- wordpress (33)
- work-other (2)
- 低代码 (1)
- 体味生活 (40)
- 前端 (21)
- 大数据 (8)
- 游戏开发 (9)
- 爱上海 (19)
- 读书 (4)
- 软件 (3)