Question

用 T-SQL语句在创建一个数据库!?

用 T-SQL语句在C:\DATA\与D:\DATA\文件中创建一个教师信息数据库TEACHER,该数据包含什么?
帮个忙!谢谢!

Answer 1

create database teacher
on
(
name=Teacher_dat,
filename='C:\Data\Teacher.mdf',
size=10,
maxsize=50,filegrowth=5
)
log on
(
name='teacher_log',
filename='c:\data\teacher.ldf',
size=5,
maxsize=25mb,
filegrowth=5
)