UC知道用SQL语句创建一个数据库，我错在哪？
来源：百度知道 编辑：UC知道 时间：2024/05/27 23:39:24
create database PRODUCT
on primary
(
name=PRODUCT,
filename='C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\PRODUCT.mdf'
size=10,
maxsize=50,
filegrowth=10%
)
log on
(
name=PRODUCT_log,
filename='C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\PRODUCT_log.ldf',
size=10,
maxsize=50,
filegrowth=10%
)
go
---------------------------
Msg 153, Level 15, State 1, Line 6
在 CREATE/ALTER DATABASE 语句中选项 size 的用法无效。
on primary
(
name=PRODUCT,
filename='C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\PRODUCT.mdf'
size=10,
maxsize=50,
filegrowth=10%
)
log on
(
name=PRODUCT_log,
filename='C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\PRODUCT_log.ldf',
size=10,
maxsize=50,
filegrowth=10%
)
go
---------------------------
Msg 153, Level 15, State 1, Line 6
在 CREATE/ALTER DATABASE 语句中选项 size 的用法无效。
在这句后面加一个逗号“,”
filename='C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\PRODUCT.mdf'
USE master
GO
IF EXISTS (SELECT * FROM sysdatabases WHERE name='bbsinfo')
DROP DATABASE bbsinfo
CREATE DATABASE bbsinfo
ON PRIMARY
(
NAME='bbsinfo',
FILENAME='E:\bbsinfo.mdf',
SIZE=20,
MAXSIZE=100,
FILEGROWTH=2
)
LOG ON
(
NAME='bbsinfo_log',
FILENAME='E:\bbsinfo_log.ldf',
SIZE=2,
MAXSIZE=20,
FILEGROWTH=15%
)
GO
比较比较