发布于 2016-04-15 04:25:54 | 124 次阅读 | 评论: 0 | 来源: 网友投递

这里有新鲜出炉的SQL Server教程，程序狗速度看过来！

SQL Server 数据库

SQL Server 即 Microsoft SQL Server 。 SQL是英文Structured Query Language的缩写，意思为结构化查询语言。SQL语言的主要功能就是同各种数据库建立联系，进行沟通。按照ANSI(美国国家标准协会)的规定，SQL被作为关系型数据库管理系统的标准语言。

---

sql server 2005 安装在 2K3 server 系统上 需要 sp1补丁，安装sp1补丁时遇到问题无法安装解决办法，将如下代码保存为reg文件，导入注册表即可成功安装sp1补丁

Windows Registry Editor Version 5.00 

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion] 
"ProductId"="69713-640-9722366-45198" 

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion] 
"CurrentBuild"="1.511.1 () (Obsolete data - do not use)" 
"InstallDate"=dword:3f6c976d 
"ProductName"="Microsoft Windows Server 2003" 
"RegDone"="" 
"SoftwareType"="SYSTEM" 
"CurrentVersion"="5.2" 
"CurrentBuildNumber"="3790" 
"BuildLab"="3790.srv03_rtm.030324-2048" 
"CurrentType"="Uniprocessor Free" 
"ProductId"="69713-640-9722366-45198" 
"DigitalProductId"=hex:a4,00,00,00,03,00,00,00,36,39,37,31,33,2d,36,34,30,2d,\ 
39,37,32,32,33,36,36,2d,34,35,31,39,38,00,5a,00,00,00,41,32,32,2d,30,30,30,\ 
30,31,00,00,00,00,00,00,00,00,e5,3f,e9,6a,2c,ed,25,35,12,ec,11,c9,8d,01,00,\ 
00,00,00,00,37,03,6d,3f,44,22,06,00,00,00,00,00,00,00,00,00,00,00,00,00,00,\ 
00,00,00,00,00,00,00,00,00,00,00,31,32,32,32,30,00,00,00,00,00,00,00,dc,0f,\ 
00,00,bf,4a,94,6c,80,00,00,00,15,18,00,00,00,00,00,00,00,00,00,00,00,00,00,\ 
00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,34,79,ca,d7 
"LicenseInfo"=hex:71,84,c7,56,a0,d6,10,6e,70,b4,9f,e9,10,1a,1e,7a,01,a4,41,09,\ 
25,20,0e,80,83,80,1f,31,27,86,64,1f,31,dc,22,af,f7,7d,aa,e4,2a,b9,e5,e3,6c,\ 
e2,01,69,85,70,91,be,a7,9f,95,e5