sql´æ´¢¹ý³ÌÎÊÌâ - MS-SQL Server / »ù´¡Àà

ÒÔÏÂÊÇÒ»¸ö½¨¿â½Å±¾Ð´ÔÚ´æ´¢¹ý³ÌÖУ¬×ÜÊDZ¨´í£¬ÇëÎÊÊÇÄÄÀïÓÐÎÊÌ⣿
SQL code:

CREATE PROCEDURE newdb (@id varchar(50),@path varchar(50))
AS
declare @name varchar(50)
set @name='HDATA'+'_'+@id+'_'+CONVERT(varchar(30),DATEPART(year, GETDATE()))

IF EXISTS (SELECT name from master.dbo.sysdatabases WHERE name = @name)
DROP DATABASE [@name]

CREATE DATABASE [@name] ON (NAME = @name+'_'+'Data', FILENAME =@path+'\'+convert(varchar(30),datepart(year,getdate()))+'\'+@id+'\'+@name+'_Data.MDF', SIZE = 1, FILEGROWTH = 10%)
LOG ON (NAME = @name+'_'+'Log', FILENAME = @path+'\'+convert(varchar(30),datepart(year,getdate()))+'\'+@id+'\'+@name+'_Log.LDF' , SIZE = 1, FILEGROWTH = 10%)
COLLATE Chinese_PRC_CI_AS

exec sp_dboption @name, N'autoclose', N'true'

exec sp_dboption @name, N'bulkcopy', N'false'

exec sp_dboption @name, N'trunc. log', N'true'

exec sp_dboption @name, N'torn page detection', N'true'

exec sp_dboption @name, N'read only', N'false'

exec sp_dboption @name, N'dbo use', N'false'

exec sp_dboption @name, N'single', N'false'

exec sp_dboption @name, N'autoshrink', N'true'

exec sp_dboption @name, N'ANSI null default', N'false'

exec sp_dboption @name, N'recursive triggers', N'false'

exec sp_dboption @name, N'ANSI nulls', N'false'

exec sp_dboption @name, N'concat null yields null', N'false'

exec sp_dboption @name, N'c