我的触发器

/*
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,
 '删除成功'
)