实验三 创建数据库和数据表 实验报告.docVIP

实验三 建立数据库university 建表： Student: USE [university] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[student]( [snum] [nchar](6) COLLATE Chinese_PRC_CI_AS NOT NULL, [sname] [nchar](10) COLLATE Chinese_PRC_CI_AS NULL, [sex] [nchar](2) COLLATE Chinese_PRC_CI_AS NULL, [dept] [nchar](20) COLLATE Chinese_PRC_CI_AS NULL, [birthday] [datetime] NULL, [telephone] [nchar](12) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_student] PRIMARY KEY CLUSTERED ( [snum] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[student] WI