创库语法.sql

SQL语言常用的一些命令各代码

create database tt1
on
( name=tt1_dat,
  filename='C:\Program Files\Microsoft SQL Server\MSSQL\Data\tt1dat.mdf',
  size=10,
  maxsize=50,
  filegrowth=5)
log on
( name='tt1_log',
  filename='C:\Program Files\Microsoft SQL Server\MSSQL\Data\tt1log_ldf',
  size=5,
  maxsize=25,
  filegrowth=5)