建库Create database MyDB on primary(name=MyDB_data,filename=d:zxyMyDB.mdf,size=10,maxsize=unlimited,filegrowth=10%)log on(name=MyDB_log,filename=d:zxyMyDB.ldf,size=1,maxsize=5,filegrowth=1)建表CREATE TABLE UserInfo (UserName CHAR(20) not null PRIMARY KEY,-列的非空约束和主键约束和UNIQUE 不能同时约束UserPwd CHAR(20) NOT NULL)CREATE TABLE SpecialtyInfo (SpeNo CHAR(5) not null PRIMARY KEY,SpeName VARCHAR(20) NOT NULL,DepNo CHAR(4)not null foreign key references DepartInfo(DepNO) , -列的外键约束UNIQUE(SpeNo, SpeName) 表的单值约束CONSTRAINT S_UNIQ可省CREATE TABLE CourseInfo ( CNo CHAR(8) NOT NULL PRIMARY KEY,CName VARCHAR(50) NOT NULL,Credit TINYINT NOT NULL,ClassHour TINYINT NOT NULL )CREATE TABLE SC( StuNo CHAR(12) NOT NULL foreign key references StudentInfo(StuNo), CNo CHAR(8) NOT NULL foreign key references CourseInfo(CNo),OrdinarySc FLOAT CHECK(OrdinarySc =0 AND OrdinarySc =0 AND Grade =0 AND Grade =100), UNIQUE(StuNo) -主键和单值不能同时作用于列约束插入数据INSERT INTO DepartInfo VALUES (D001,计算机)INSERT INTO DepartInfo VALUES (D002,外语)INSERT INTO SpecialtyInfo VALUES (S0001,计算机应用, D001)INSERT INTO SpecialtyInfo VALUES (S0002,网络, D001)INSERT INTO StudentInfo VALUES (200302303055,孙浩,男 ,1983-12-4,2003,S0001,长沙)INSERT INTO StudentInfo VALUES (200330000003,王小,女 ,1985-9-2,2003,S0001,衡阳)INSERT INTO CourseInfo VALUES (08101390,C语言,4,68 ) INSERT INTO CourseInfo VALUES (00467108,BEC,4,60)INSERT INTO SC VALUES (200403044011,00467108,85,88)INSERT INTO SC(StuNo,CNo)VALUES (200403044020,00467108)INSERT INTO TeacherInfo VALUES (T0001,黄刚 ,男,1970-4-22 ,副教授,D001,T0001,07314614888,HG163.com)INSERT INTO TeacherInfo VALUES (T0002,周倩,女,1981-11-5 ,助教,D001,T0001,07314614881,ZQ126.com)