27,579
社区成员
发帖
与我相关
我的任务
分享
alter PROC Db
@Dbname varchar(20),
@Table1 varchar(20)=null,
@Table2 varchar(20)=null
AS
declare @s nvarchar(4000)
set @s='CREATE DATABASE '+@Dbname
exec sp_executesql @s --建库
set @s=
isnull(
' CREATE TABLE '+@Dbname+'..'+@Table1+'(id int,title varchar(50),content text,addtime smalldatetime)','')
+isnull(
' CREATE TABLE '+@Dbname+'..'+@Table2+'(id int,title varchar(50),content text,addtime smalldatetime)','')
--print @s -- 显示语句
exec sp_executesql @s --建表
go
exec Db T,t1,t2--测试
CREATE PROC Db
@Dbname varchar(20),
@Table1 varchar(20),
@Table2 varchar(20)
AS
EXEC('CREATE DATABASE '+@Dbname)
EXEC('USE '+@Dbname+' CREATE TABLE '+@Table1+'(id int,title varchar(50),content text,addtime smalldatetime)')
EXEC('USE '+@Dbname+' CREATE TABLE '+@Table2+'(id int,title varchar(50),content text,addtime smalldatetime)')
go
Db 'testtt','tab1','tab2'
use master
go
create database [data]
go
use [data]
go
create table table1(id int,title char(1),content char(10),addtime datetime)
go
create table table2(id int,title char(1),content char(10),addtime datetime)
go
create database data
go
use data
go
create table table1(id int,title varchar(20),content varchar(50),addtime datetime)
go
create table table2(id int,title varchar(20),content varchar(50),addtime datetime)