SQLServer数据库学习总结

1.SQL基础
SQL Server2000安装、配置，服务器启动、停止，企业管理器、查询分析器
第一代数据库--网状数据库和层次数据库；第二代数据库--关系数据库
数据库（DB）；数据库管理系统（DBMS）；数据库系统（DBS）
SQL Server 2000 提供了不同版本：企业版、标准版、个人版、开发版

SQL Server中的数据类型：整数：int,smallint,tinyint,bigint;浮点数：real,float,decimal;二进制：binary,varbinary;逻辑：bit；字符：char,nchar,varchar,nvarchar；文本和图形：text,ntext,image；日期和时间：datetime,smalldatetime；货币：money,smallmoney

数据库的创建和删除；数据库表的创建、修改和删除

数据完整性：实体完整性：Primary Key,Unique Key,Unique Index,Identity Column；域完整性：Default,Check,Foreign Key,Data type，Rule；参照完整性：Foreign Key,Check,Triggers,Procedure；用户定义完整性：Rule,Triggers,Procedure;Create Table中得全部列级和表级约束

SQL Server中有5种约束：主键约束（Primary Key Constraint）、默认约束（Default Constraint）、检查约束（Check Constraint）、唯一性约束（Unique Constraint）、外键约束（Foreign Key Constraint）.

http://ameblo.jp/ny6688/entry-11803647598.html
http://ameblo.jp/ny6688/entry-11803647598.html
http://ameblo.jp/ny6688/entry-11803647598.html
http://ameblo.jp/ny6688/entry-11803647598.html
http://ameblo.jp/ny6688/entry-11803647598.html
http://ameblo.jp/ny6688/entry-11803647598.html
http://ameblo.jp/ny6688/entry-11804329751.html
http://v.17173.com/playlist_16714724?retcode=0
http://v.17173.com/playlist_16714190?retcode=0
http://v.17173.com/playlist_16713730?retcode=0
http://v.17173.com/playlist_16713159?retcode=0
http://v.17173.com/playlist_16712492?retcode=0
http://v.17173.com/playlist_16711836?retcode=0
http://v.17173.com/playlist_16711185?retcode=0
http://v.17173.com/playlist_16710392?retcode=0
http://v.17173.com/playlist_16709870?retcode=0
http://v.17173.com/playlist_16709314?retcode=0
http://v.17173.com/playlist_16708799?retcode=0
http://v.17173.com/playlist_16707906?retcode=0
http://v.17173.com/playlist_16707373?retcode=0
http://v.17173.com/playlist_16706913?retcode=0
http://v.17173.com/playlist_16706474?retcode=0
http://v.17173.com/playlist_16705925?retcode=0
http://v.17173.com/playlist_16705178?retcode=0
http://v.17173.com/playlist_16704637?retcode=0
http://v.17173.com/playlist_16704041?retcode=0
http://v.17173.com/playlist_16703463?retcode=0
http://v.17173.com/playlist_16702431?retcode=0
http://v.17173.com/playlist_16701911?retcode=0
http://v.17173.com/playlist_16701425?retcode=0
http://v.17173.com/playlist_16700997?retcode=0
http://v.17173.com/playlist_16700514?retcode=0
http://v.17173.com/playlist_16700062?retcode=0
http://v.17173.com/playlist_16699521?retcode=0
http://v.17173.com/playlist_16699020?retcode=0
http://v.17173.com/playlist_16697996?retcode=0
http://v.17173.com/playlist_16697624?retcode=0
http://v.17173.com/playlist_16697178?retcode=0
http://v.17173.com/playlist_16696824?retcode=0
http://v.17173.com/playlist_16696465?retcode=0
http://v.17173.com/playlist_16696155?retcode=0
http://v.17173.com/playlist_16695772?retcode=0
http://v.17173.com/playlist_16695379?retcode=0
http://v.17173.com/playlist_16694970?retcode=0
http://v.17173.com/playlist_16694572?retcode=0
http://v.17173.com/playlist_16694196?retcode=0
http://v.17173.com/playlist_16693811?retcode=0
http://v.17173.com/playlist_16693453?retcode=0
http://v.17173.com/playlist_16693142?retcode=0
http://v.17173.com/playlist_16691213?retcode=0
http://v.17173.com/playlist_16690859?retcode=0
http://v.17173.com/playlist_16690523?retcode=0
http://v.17173.com/playlist_16690167?retcode=0
http://v.17173.com/playlist_16689466?retcode=0
http://v.17173.com/playlist_16689088?retcode=0
http://v.17173.com/playlist_16688808?retcode=0
http://v.17173.com/playlist_16688349?retcode=0