您所在位置：主题：请教一个语句编写,小弟急等,回帖加分
随行
[专家分：30] 发布于 2006-04-22 18:07:00
create proc CreateDB @path varchar(50) = null as
IF not EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'YHERP')
create database YHERP
on (name = YHERP,filename =@path + '\YHERP.ldf',size = 1mb,filegrowth =10%)
log on(name = YHERP,filename =@path + '\YHERP.ldf',size = 1mb,filegrowth = 10%)
----上面语句是错的，错在filename那里，请问怎么写???----
IF not EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'YHERP')
create database YHERP
on (name = YHERP,filename =@path + '\YHERP.ldf',size = 1mb,filegrowth =10%)
log on(name = YHERP,filename =@path + '\YHERP.ldf',size = 1mb,filegrowth = 10%)
----上面语句是错的，错在filename那里，请问怎么写???----