动态创建数据库！

最新推荐文章于 2024-07-08 21:48:08 发布

itblog

最新推荐文章于 2024-07-08 21:48:08 发布

阅读量1.1k

点赞数

分类专栏： SQL Sever 文章标签：数据库 collation sql database go

SQL Sever 专栏收录该内容

66 篇文章 0 订阅

订阅专栏

create proc pr_createdb
@DBNAME sysname,
@collation_name sysname,
@dNAME sysname,
@dFILENAME sysname,
@dSIZE int,
@dMAXSIZE int,
@dFILEGROWTH,
@lNAME sysname,
@lFILENAME sysname,
@lSIZE int,
@lMAXSIZE int,
@lFILEGROWTH
as
declare @sql varchar(8000)
set @sql='CREATE DATABASE '+ @DBNAME+' ON (
   NAME = '+@dNAME+',
   FILENAME = '''+@dFILENAME+''',
   SIZE = '+cast(@dSIZE as varchar(10))+',
   MAXSIZE = '+cast(@dMAXSIZE as varchar(10))+',
   FILEGROWTH = '+cast(@dFILEGROWTH as varchar(10))+' )
LOG ON (
   NAME = '+@lNAME+',
   FILENAME = '''+@lFILENAME+''',
   SIZE = '+cast(@lSIZE as varchar(10))+',
   MAXSIZE = '+cast(@lMAXSIZE as varchar(10))+',
   FILEGROWTH = '+cast(@lFILEGROWTH as varchar(10))+' )
COLLATE '+@collation_name