create procedure 导出空数据库
(
@名称 varchar(50)
)
as
declare @sql varchar(3000)
set @sql='
create database '+@名称+'
ON
(
name = '+@名称+'_Data,
filename = '''C:\'+@名称+'_Data.MDF'',
size = 10,
filegrowth = 15%
)
LOG ON
(
name = '''+@名称+'_Log'',
filename = '''C:\'+@名称+'_Log.LDF'',
size = 5MB,
maxsize = 25MB,
filegrowth = 5MB
)'
exec(@sql)
GO报错:服务器: 消息 170,级别 15,状态 1,过程 导出空数据库,行 13
第 13 行: '\' 附近有语法错误。
(
@名称 varchar(50)
)
as
declare @sql varchar(3000)
set @sql='
create database '+@名称+'
ON
(
name = '+@名称+'_Data,
filename = '''C:\'+@名称+'_Data.MDF'',
size = 10,
filegrowth = 15%
)
LOG ON
(
name = '''+@名称+'_Log'',
filename = '''C:\'+@名称+'_Log.LDF'',
size = 5MB,
maxsize = 25MB,
filegrowth = 5MB
)'
exec(@sql)
GO报错:服务器: 消息 170,级别 15,状态 1,过程 导出空数据库,行 13
第 13 行: '\' 附近有语法错误。
(
@名称 varchar(50)
)
as
declare @sql varchar(3000)
set @sql='
create database '+@名称+'
ON
(
name = '+@名称+'_Data,
filename = ''C:\'+@名称+'_Data.MDF'',
size = 10,
filegrowth = 15%
)
LOG ON
(
name = '''+@名称+'_Log'',
filename = ''C:\'+@名称+'_Log.LDF'',
size = 5MB,
maxsize = 25MB,
filegrowth = 5MB
)'
exec(@sql)
GO
filename = ''C:\'+@名称+'_Log.LDF'',
就OK了,两个地方都需要修改