唉,我自己解决了!
IF NOT EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'JianShen')
begin
declare @dbpath nvarchar(200)
declare @sql nvarchar(1000)
exec master.dbo.xp_regread 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\MSSQLSERVER\setup','SQLDataRoot',@dbpath output
set @sql='CREATE DATABASE [JianShen] ON (NAME = JianShen, FILENAME =''' + @dbpath + '\data\JianShen.MDF'' , SIZE = 3, FILEGROWTH = 10%) LOG ON (NAME = JianShen_log, FILENAME =''' + @dbpath + '\data\JianShen_log.LDF'' , SIZE = 1, FILEGROWTH = 10%)'
exec(@sql)
end
IF NOT EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'JianShen')
begin
declare @dbpath nvarchar(200)
declare @sql nvarchar(1000)
exec master.dbo.xp_regread 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\MSSQLSERVER\setup','SQLDataRoot',@dbpath output
set @sql='CREATE DATABASE [JianShen] ON (NAME = JianShen, FILENAME =''' + @dbpath + '\data\JianShen.MDF'' , SIZE = 3, FILEGROWTH = 10%) LOG ON (NAME = JianShen_log, FILENAME =''' + @dbpath + '\data\JianShen_log.LDF'' , SIZE = 1, FILEGROWTH = 10%)'
exec(@sql)
end
begin
declare @dbpath nvarchar(200)
declare @v_sql nvarchar(1000)
exec master.dbo.xp_regread 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\MSSQLSERVER\setup','SQLDataRoot',@dbpath output
set @v_sql = 'CREATE DATABASE Music ON (NAME = Music, FILENAME =
'''+@dbpath + '\data\Music.MDF'''+' , SIZE = 3, FILEGROWTH = 10%) LOG ON
(NAME = Music_log, FILENAME = '''+@dbpath + '\data\Music_log.LDF'''+' , SIZE = 1, FILEGROWTH = 10%)'
exec (@v_sql)
end