34,590
社区成员
发帖
与我相关
我的任务
分享
SQL codeCREATE TRIGGER [dbo].[T_LeaguerInfos_Log]
ON CTI_2008_08 -- CTI_ YEAR(GETDATE()) _ MONTH(GETDATE())这个名字部分怎么弄?
MustID callID name username tel
1 1 王某 js001 13141250137
create trigger trg_Test on a
for insert
as
insert into b select * from a not exit(select * from b )
if object_id('[dbo].[T_LeaguerInfos_Log]') is null
begin
declare @a varchar(500)
select @a=stuff(convert(varchar(7),getdate(),120),5,1,'_')
exec ('create trigger [dbo].[T_LeaguerInfos_Log] on CTI_'+@a+' for insert as
insert B..CTI_Missing select * from inserted ')
end