SQL server200实例.docVIP

/*[例1]??建立一个“学生”表Student，它由学号Sno、姓名Sname、性别Ssex、年龄Sage、??? 所在系Sdept五个属性组成。其中学号不能为空，值是唯一的，并且姓名取值也唯一。*/??? ????CREATE?TABLE?Student1??? ????????(Sno???????CHAR(5)??NOT?NULL??UNIQUE,???? ?????????Sname??CHAR(20)??UNIQUE,????????????? ?????????Ssex??????CHAR(2),??? ?????????Sage??????INT,??? ?????????Sdept????CHAR(15));???? /*[例2-0]??建立一个“课程”表Course，它由课程号Cno，课程名Cname，学分Ccredit组成，其中Cno为主码。??? CREATE?TABLE?Course(??? ?????????????Cno?CHAR(3)?,???? ?????????????Cname??char(50),??? ?????????????Ccredit??int,??? ?????????????Primary?key?Cno))*/??? CREATE?TABLE?Course(??? ?????????????Cno?CHAR(3)?,??