if not exists (select * from sysobjects where id = object_id('dbo.Sys_Log${date:format=yyyyMM}') and OBJECTPROPERTY(id, 'IsUserTable') = 1) create table dbo.Sys_Log${date:format=yyyyMM} ( id bigint identity(1,1) not null, createtime datetime NOT NULL, appname varchar(50) NOT NULL, modulename varchar(50) NULL, level varchar(50) NOT NULL, logger varchar(1024) NULL DEFAULT NULL, msg text NULL, userid varchar(50) NULL DEFAULT NULL, url varchar(1024) NULL DEFAULT NULL, ip varchar(255) NULL DEFAULT NULL, tenantId varchar(50) NULL, CONSTRAINT [PK_dbo.Sys_Log${date:format=yyyyMM}] PRIMARY KEY CLUSTERED ([id] ASC) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) INSERT INTO dbo.Sys_Log${date:format=yyyyMM}(createtime, appname, modulename, level, logger, msg,userid, url, ip,tenantId) VALUES (@CreateTime, @AppName,@ModuleName, @Level, @Logger, @Msg, @UserId, @Url, @IP,@TenantId);