SQL整套学习资料

奉献给 SQL 初学者们得终极教材 < 上一篇 | 下一篇 > 此教材可以说涉及得范围就是非常广得。。我们平常写得 SQL 语句都就是出现在里面得。。且每一种方法都有案例，所以说假如您把所有得案例应用理解透得话。。可以说您已经成为高手了。。知识都就是得靠自己去掌握得。。多瞧，多想。多问。多动手。信任您一定很快掌握得。。use mastergo--创建数据库 book_managecreate database book_manageon( name = book_manage_primary, = 'd:\data\book_manage、mdf', size = 10, maxsize = 20, = 5)log on ( name = book_manage_log, = 'd:\data\book_manage、ldf', size = 5, maxsize = 20, = 5)go --查瞧 book_manage 数据库信息exec sp_helpdb book_manage --修改数据库日志文件扩展空间alter database book_manage modify file ( name = book_manage_log, = 5)--创建新表use book_managegocreate table tb_bookinfo( book_ID char(6) not null, bookname char(30) not null, price decimal(18,2) not null, authorID char(4), publishID char(4))create table tb_authorinfo( authorID char(4) not null, authorname char(20) not null, sex char(2), age tinyint, authaddress char(30))gocreate table tb_pubinfo( publishID char(4) not null, pubname char(20) not null, pubaddress char(30))create table temp1( temID char(4) not null, temname varchar(30) not null default '默认名称')create table tbl_a( emp_id char(2) not null, emp_name char(10) not null, emp_age char(2))create table tbl_b( emp_id char(2) not null, spend char(10) not null, level char(10))--删除表drop table temp1--添加 tb_authorinfo 表信息insert into tb_bookinfo values('000008','asp、net',54、5,'A004','P106')insert into tb_authorinfo values('A004','黄薇','男',25,'济南')insert into tb_pubinfo values('P106','山东出版社','济南')--查询各个表信息select * from tb_bookinfo select * from tb_pubinfoselect * from tb_authorinfo--备份一个新表select * into Btb_bookinfo from tb_bookinfoselect * into Btb_authorinfo from tb_authorinfoselect *...