数据库SQLSERVER简单例子

创建数据库：

`CREATE DATABASE 数据库名 
ON
(
    NAME = XX,
    FILENAME = 'xx.mdf',
    SIZE = 5MB,
    MAXSIZE = 20MB,
    FILEGROWTH = 20%
)
LOG ON 
(
    NAME = Epiphany,
    FILENAME = 'E:\SQL SERVER 2008\Epiphany_log.ldf',
    SIZE = 2MB,
    MAXSIZE = 10MB,
    FILEGROWTH = 1MB
);`

创建基本表：

`create table sc
(
	sno char(8) not null,
	cno char(2