资源描述：
《基础SQL语句大全.doc》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。
1、第一章：--创建数据库createdatabasemydbon(name=mydb_Data,filename='D:DBFilemydb_Data.mdf',size=2MB,maxsize=10MB,filegrowth=1MB)logon(name=mydb_Log,filename='D:DBFilemydb_Log.ldf',size=1MB,maxsize=10MB,filegrowth=10%)--查看数据库信息execsp_helpdbmydbusemydb--修改信息alterdatabase
2、mydbmodifyfile(name=mydb_Data,size=3MB)--修改数据库名称alterdatabasefirstdbmodifyname=seconddbexecsp_renamedb'seconddb','firstdb'--删除数据库dropdatabasefirstdbcreatetablettt(idint)第二章：--打开自己的数据库usemydb--创建简单表createtabletb1(sidint,snamevarchar(20),sexchar(2))select*fromtb1-
3、-自动获取列值的表--default约束createtabletb2(sidint,snamevarchar(20),sexchar(2)default'男')select*fromtb2insertintotb2values(1,'张三','男')insertintotb2(sid,sname)values(2,'李四')insertintotb2values(3,'王五',null)--自动编号createtabletb3(sidintidentity(1000,10),snamevarchar(20))selec
4、t*fromtb3insertintotb3values('张三')insertintotb3values('李四')insertintotb3values('王五')deletefromtb3wheresid=1020insertintotb3values('赵六')--主键约束createtablestudents(snochar(4)primarykey,snamevarchar(20)notnull,ageint)select*fromstudentsinsertintostudentsvalues('s001
5、','张三',21)insertintostudentsvalues('s001','张三',21)--errorinsertintostudents(sname,age)values('张三',21)--errorinsertintostudents(sno,age)values('s002',22)--errorinsertintostudentsvalues('s002','李四',21)insertintostudents(sno,sname)values('s003','王五')--课程表createtabl
6、ecourse(cnoint,cnamevarchar(30),constraintpk_courseprimarykey(cno))select*fromcourseinsertintocoursevalues(1,'C#基础')insertintocoursevalues(1,'SQLServer')insertintocoursevalues(2,'SQLServer')insertintocourse(cname)values('WindowsForm')--成绩表(学号，课程号，成绩)createtables
7、core(snochar(4)referencesstudents(sno),cnoint,gradeint,Constraintfk_courseforeignkey(cno)referencescourse(cno),Constraintpk_scoreprimarykey(sno,cno))select*fromstudentsselect*fromcourseselect*fromscoreinsertintoscorevalues('ssss',3,76)--errorinsertintoscorevalue
8、s('s001',3,76)--errorinsertintoscorevalues('s001',1,76)insertintoscorevalues('s002',1,76)insertintoscorevalues('s002',null,75)--唯一性约束createtabletb4(tidintunique,tname
