《SQL Server 2005实用教程》实验答案.docVIP

实验二 2.实验内容 （1） CREATE DATABASE StuInfo ON  PRIMARY (NAME = StuInfo _Data,，?? ??FILENAME = D:\ StuInfo.Mdf,??? ?SIZE =3MB, MAXSIZE = 10MB,?? ??FILEGROWTH =1 MB) LOG ON (NAME = StuInfo _Log ，?? ??FILENAME = D:\ StuInfo _Log.Ldf, ????SIZE = 1MB,???? MAXSIZE =5MB,???? FILEGROWTH = 1MB) GO （2） --创建学生表T_Student USE Stuinfo GO CREATE TABLE t_student( S_number char(8) NOT NULL PRIMARY KEY, S_name char(10) NOT NULL, Sex char(2) NULL CHECK(Sex=男 or Sex=女), Birthday datetime , Nation nvarchar(10) , Politics varchar(10) , Department nvarchar(12) , Address