sy1_1_1.sql

来自「关于SQL数据库的实验代码和程序及一些函数的应用」· SQL 代码 · 共 14 行

use master
create database pay
        on
           (name=pay1
             ,filename='c:\Program Files\Microsoft SQL Server\MSSQL\Data\paydata1.mdf'
             ,size=10
             ,maxsize=100
             ,filegrowth=5%)
       log on
           (name=pay3
             ,filename='c:\Program Files\Microsoft SQL Server\MSSQL\Data\paylog.ldf'
             ,size=5
             ,maxsize=25
             ,filegrowth=10)