if object_id('DataList') is not null drop table DataList
create table DataList(dbname varchar(10))
insert DataList select 'zw0001' union
select 'zw0002' union
select 'zw0003' union
select 'zw0004' declare @max int,@min int,@dbname varchar(10)
declare @DataList table(iid int identity(1,1),dbname varchar(10))
insert @DataList select * from DataList
select @min=0,@max=count(*) from @DataList
while @min<@max
begin
set @min=@min+1
select @dbname=dbname from @DataList where iid=@min
exec('create database '+@dbname)
end
create table DataList(dbname varchar(10))
insert DataList select 'zw0001' union
select 'zw0002' union
select 'zw0003' union
select 'zw0004' declare @max int,@min int,@dbname varchar(10)
declare @DataList table(iid int identity(1,1),dbname varchar(10))
insert @DataList select * from DataList
select @min=0,@max=count(*) from @DataList
while @min<@max
begin
set @min=@min+1
select @dbname=dbname from @DataList where iid=@min
exec('create database '+@dbname)
end
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货