SQL server2000语法.doc

创建/修改库 create database xk on primary( name=x1_data, filename=d:\xk\x1_data.mdf, size=10mb,maxsize=50mb, filegrowth=10% ) log on( name=x1_log, filename=d:\x1_log.ldf, size=1mb, filegrowth=10% ) exec sp_helpdb xk alter database xk add filegroup fg1 alter database xk add file( name=x1_ndata, filename=d:\xk\x1_ndata.ndf, size=1mb, filegrowth=10% )to filegroup fg1 alter database xk modify file( name=x1_ndata, size=10mb, filegrowth=10% ) alter database xk modify file( name=x1_log, size=10 ) exec sp_helpdb xk 删除库 use xk alter database xk remove file x1_ndata alter database xk remove filegroup fg1 alter database xk modify name=ly drop database ly 创建/删除表 use xk create table student( stuno char(4) not null primary key, stuname varchar(10)not null, age tinyint, sex char(4), address varchar(20) ) create table course( couno char(4) not null primary key, couname varchar(20), kind varchar(20), credit tinyint, teacher varchar(10), coutime datetime ) create table grade( stuno char(4) not null, couno char(4) not null, stugrade tinyint, credit tinyint ) exec sp_help student exec sp_help course exec sp_help grade drop table grade insert into student values(1004,特兰克思,18,男,南京市鼓楼区) insert into course values(c004,三分归元气,拳、掌、腿、气,5,雄霸,16:00) insert into grade values(1004,c004,90,10) exec sp_spaceused student /*查询表中记录数*/ 修改表 use xk alter table student add phone varchar(15) alter table student drop column mingzu alter table student alter column sex varchar(2) exec sp_rename stu,student exec sp_spaceused student insert course select * from newcourse /*将表newcourse内容插入表course中*/ select couno,couname,teacher,coutime into newcourse from course where kind=气 /*将表course内容插入表中newcourse*/ update student set stuname=孙悟空 where stuno=1003 update grade set stuno=student.stuno from grade join student on grade.stuno=student.stuno delete from grade where credit=10 insert grade values(1001,c001,90,10) 约束 use xk alter table grade ad