exec proc_created_database_log
根据日期动态创建数据库的存储过程
标签：
根据日期动态创建数据库的存储过程
=============================================
-- Author:<Author,,Name>
-- Create date: <Create Date,,>
-- Description:<Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[proc_created_database_log]
AS
declare @sqlStr varchar(200)
BEGIN
set @sqlStr=‘if not exists (select * from master.dbo.sysdatabases where name=‘‘Log‘+convert(varchar(8),getdate()+1,112)+‘‘‘)
create database Log‘+convert(varchar(8),getdate()+1,112);
exec (@sqlStr);
END