SQL数据库代码记录保存

大学期间的一些数据库代码O(∩_∩)O哈哈~

当时年少无知！

/*创建数据库*/
create database ST
ON
(
	NAME="ST",
	FILENAME="D:\SQL\ST.MDF",
	SIZE=5MB,
	MAXSIZE=50mb,
	FILEGROWTH=10%
)
LOG ON 
(
	NAME="ST_LOG",
	FILENAME="D:\SQL\ST.LDF",
	SIZE=2MB,
	MAXSIZE=5MB,
	FILEGROWTH=1MB
)


/*创建表*/
use ST
GO
create table Student
(
	Sno char(10) not null,
	Sname char(10) not null,
	primary key(Sno,Sname),
	Ssex bit null default 1,
	Sage int null,
	Sdept char(20) null default '空'
)


GO
create table Course
(
	Cno char(10) not null,
	Cname char(10) not null,
	primary key(Cno),
	Cpno char(2) null,
	Ccredit int null
)


GO
create table SC
(
	Sno char(10) not null,
	Cno char(10) not null,
	Grade int default 0,
	primary key(Sno,Cno)
)

GO
create table xsb1
(
	Sno char(10) not null,
	Cno char(10) not null,
	Grade int default 0,
	primary key(Sno,Cno)
)

/*修改表结构*/
ALTER TABLE xsb1
	add name char(8),
	Sdate char(10)

ALTER TABLE xsb1
	alter column Sdate smalldatetime

ALTER TABLE xsb1
	drop column Sdate

/*删除表*/
drop table xsb1


/*添加数据*/
/*指定列*/
use ST
INSERT INTO Student(Sno,Sname,Ssex,Sage,Sdept)
	values('200215121','李勇',1,20,'CS'),
	('200215122','刘晨',0,19,'CS'),
	('200215123','王敏',0,18,'MA'),
	('200215125','张立',1,19,'IS')
/*不指定列*/
use ST
INSERT INTO Student
	values('200215121','李勇',1,20,'CS'),
	('200215122','刘晨',0,19,'CS'),
	('200215123','王敏',0,18,'MA'),
	('200215125','张立',1,19,'IS')
go
INSERT INTO Course
	values('1','数据库','5',4),
	('2','数学','',2),
	('3','信息系统','1',4),
	('4','操作系统','6',3),
	('5','数据结构','7',4),
	('6','数据处理','',2),
	('7','PASCAL语言','6',4)
go
INSERT INTO SC
	values('200215121','1',92),
	('200215121','2',85),
	('200215121','3',88),
	('200215122','2',90),
	('2