1: CREATE DATABASE StudentsSys ON PRIMARY(NAME = 'StudentsSys' ,FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\StudentsSys.mdf''SIZE = 10mb ,MAXSIZE = UNLIMITED,FILEGROWTH = 10% )LOG ON (NAME = 'StudentsSys_log',FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\StudentsSys.ldf',SIZE = 1MB,MAXSIZE = 5MB,FILEGROWTH = 1MB)2:USE StudentsSys GOCREATE TABLE [dbo].[tblStudent]( [id] [int] NOT NULL, [photo] [varchar](50) COLLATE Albanian_BIN NULL, CONSTRAINT [PK_A] PRIMARY KEY CLUSTERED ( [id] ASC)GO表2 同上3:USE StudentsSys GOALTER TABLE tblStudentDROP COLUMN photoGOALTER TABLE tblStudent ADD Email varchar(30)GOALTER TABLE tblStudentWITH CHECK ADDCONSTRAINT [CK_A] CHECK(([Email] like '%@%'))4:INSERT INTO tblStudent([id],[Email])VALUES
(
,)这个自己往上写吧5:DELETE FROM tblStudent WHERE DATA < '1990'6:UPDATE tblStudent SET Email = '[email protected]' WHERE Email = '[email protected]'看一下吧,累人的活啊,强烈要求加分 呵呵 |