34,587
社区成员
发帖
与我相关
我的任务
分享
create trigger tr_name
on info_last
for insert
as
begin
declare @tbname varchar(20)
set @tbname='history'+replace(convert(varchar(5),getdate(),120),'-','')
--判断表是否存在
if object_id(@tbname) is not null
begin
declare @str varchar(2000)
set @str='insert '+'history'+replace(convert(varchar(5),getdate(),120),'-','')+
' select * from info_last'
exec @str
end
else begin
declare @str varchar(2000)
set @str='create table '+'history'+replace(convert(varchar(5),getdate(),120),'-','')+
'(id int identity(1,1),列1 varchar(20),列2 varchar(20),列3 varchar(20));
insert '+'history'+replace(convert(varchar(5),getdate(),120),'-','')
+' select * from info_last'
exec @str
end
end
go
类似这样,其它的就看你了