declare @chDataFilePath varchar(255)
declare @chLogFilePath varchar(255)
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'dbSubmit')
DROP DATABASE [dbSubmit]set @chDataFilePath='C:\WINDOWS\Desktop\dbSubmit_Data.MDF'
set @chLogFilePath='C:\WINDOWS\Desktop\dbSubmit_Log.LDF'
exec('
CREATE DATABASE [dbSubmit]
ON (
NAME = N''dbSubmit_Data'',
FILENAME = N'+@chDataFilePath+' ,
SIZE = 1,
FILEGROWTH = 10%)
LOG
ON (
NAME = N''dbSubmit_Log'',
FILENAME = N'+@chLogFilePath+' ,
SIZE = 1,
FILEGROWTH = 10%)
COLLATE Chinese_PRC_CI_AS')
go
declare @chLogFilePath varchar(255)
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'dbSubmit')
DROP DATABASE [dbSubmit]set @chDataFilePath='C:\WINDOWS\Desktop\dbSubmit_Data.MDF'
set @chLogFilePath='C:\WINDOWS\Desktop\dbSubmit_Log.LDF'
exec('
CREATE DATABASE [dbSubmit]
ON (
NAME = N''dbSubmit_Data'',
FILENAME = N'+@chDataFilePath+' ,
SIZE = 1,
FILEGROWTH = 10%)
LOG
ON (
NAME = N''dbSubmit_Log'',
FILENAME = N'+@chLogFilePath+' ,
SIZE = 1,
FILEGROWTH = 10%)
COLLATE Chinese_PRC_CI_AS')
go
解决方案 »
- 求大侠指点迷经!!我安装的sql server 2005 中的安全性中的sa的登录名为什么不能改变啊
- 我用Macromedia Dreamweaver做的ASP,里面涉及建立的记录集,上面三附图有关情况麻烦解决!
- 关于CASE很奇怪很奇怪的问题,急等!!!谢谢!!!
- 问个简单问题
- SQL2008无法连接到.\SQLEXPRESS,用户'sa'登录失败(错误18456)图文解决方法
- 求救 SQL 安装启动出错
- 请高手讲解一下3程结构。view--logic--db
- 奇怪,怎么我的SQL SERVER 2000(桌面版)的查询分析器和事件查看器不能打开???
- 大家都来请来看看,不看白不看啊~~~~~~~~~~~~~~~~~~~
- 使用restore database之后,数据库名与mdf文件名不一致
- 请教pengdali(大力):
- 怎样打印出一个表的所有字段名?
declare @chLogFilePath varchar(255)
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'dbSubmit')
DROP DATABASE [dbSubmit]set @chDataFilePath='C:\WINDOWS\Desktop\dbSubmit_Data.MDF'
set @chLogFilePath='C:\WINDOWS\Desktop\dbSubmit_Log.LDF'
exec('
CREATE DATABASE [dbSubmit]
ON (
NAME = N''dbSubmit_Data'',
FILENAME = N'''+@chDataFilePath+''' ,
SIZE = 1,
FILEGROWTH = 10%)
LOG
ON (
NAME = N''dbSubmit_Log'',
FILENAME = N'''+@chLogFilePath+''' ,
SIZE = 1,
FILEGROWTH = 10%)
COLLATE Chinese_PRC_CI_AS')
go