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
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