SQL建库

--建立数据库

CREATE DATABASE [Temp]  ON PRIMARY
(
  NAME = N'Temp_Data',
  FILENAME = N'g:\temp\1\Temp_Data.MDF' ,
  SIZE = 1,
  FILEGROWTH = 10%
)

LOG ON
(
  NAME = N'Temp_Log',
  FILENAME = N'g:\temp\1\Temp_Log.LDF' ,
  SIZE = 1,
  FILEGROWTH = 10%
)