我的触发器
/*
create table tb_log
(
_id int identity(1,1) primary key ,
LogId varchar(10) ,
event varchar(50),
)
*/
create trigger our
on Test
for delete
as
declare @StuId char(8)
declare @name varchar(15)
declare @LogId varchar(20)
select @StuId=StuId from deleted--查询用户删除的学号
select @name=StuName from deleted where StuId=@StuId
select @LogId=max(LogId) from tb_log
if(@LogId is null)
set @LogId='L1001'
else
set @LogId='L'+cast(cast(substring(@LogId,2,4) as int)+1 as varchar(20))
begin
insert into tb_log values(@LogId,'删除用户['+@name+']!')
end
/*drop trigger ourtri*/
//还有一个小实列
create trigger tr_delete on T_salary
for delete
as
declare @theDate varchar(20)
set @theDate=convert(varchar,getdate(),120)//是期转化,貌似没有成功
insert into journal
values
(
'1',
@theDate,
'删除成功'
)