declare @s1 Nvarchar(1000)
declare @dt varchar(20)
set @dt=left(CONVERT(varchar(100), GETDATE(), 12),4)
set @s1= 'create proc [Radar'+ @dt+ '].[dbo].[up_name]
@BSC varchar(32),
@BSCType tinyint,
@MSC varchar(32),
@Server varchar(50),
@Re varchar(50)AS
if not exists(select 1 from dbo.[NE] where BSC = @BSC and MSC = @MSC)
begin
insert into dbo.[NE] ([BSC],[BSCType],[MSC],[Server],[Re])
values(@BSC,@BSCType,@MSC,@Server,@Re)
end'
print(@s1)
exec(@s1)
declare @dt varchar(20)
set @dt=left(CONVERT(varchar(100), GETDATE(), 12),4)
set @s1= 'create proc [Radar'+ @dt+ '].[dbo].[up_name]
@BSC varchar(32),
@BSCType tinyint,
@MSC varchar(32),
@Server varchar(50),
@Re varchar(50)AS
if not exists(select 1 from dbo.[NE] where BSC = @BSC and MSC = @MSC)
begin
insert into dbo.[NE] ([BSC],[BSCType],[MSC],[Server],[Re])
values(@BSC,@BSCType,@MSC,@Server,@Re)
end'
print(@s1)
exec(@s1)
declare @dt varchar(20)
set @dt=left(CONVERT(varchar(100), GETDATE(), 12),4)
set @s1= ' use ' + 'Radar'+ @dt+ '
go
create proc up_name
@BSC varchar(32),
@BSCType tinyint,
@MSC varchar(32),
@Server varchar(50),
@Re varchar(50)AS
if not exists(select 1 from dbo.[NE] where BSC = @BSC and MSC = @MSC)
begin
insert into dbo.[NE] ([BSC],[BSCType],[MSC],[Server],[Re])
values(@BSC,@BSCType,@MSC,@Server,@Re)
end
go'
print(@s1)
exec(@s1)
...
declare @dt varchar(20)
set @dt=left(CONVERT(varchar(100), GETDATE(), 12),4)
set @s1= ' use '+ 'Radar'+ @dt + char(10) + '
exec('' create proc up_name
@BSC varchar(32),
@BSCType tinyint,
@MSC varchar(32),
@Server varchar(50),
@Re varchar(50)AS
if not exists(select 1 from dbo.[NE] where BSC = @BSC and MSC = @MSC)
begin
insert into dbo.[NE] ([BSC],[BSCType],[MSC],[Server],[Re])
values(@BSC,@BSCType,@MSC,@Server,@Re)
end'')'
print(@s1)
exec(@s1)
我要做的是每个月的第一天自动往这个库里添加表和存储过程,