简单的问题请教
create trigger delete_employee on employee
for delete
as
declare @typeid varchar(10)
select typeid=@typeid from deleted
delete from loginuser where etypeid=@typeid
go

这个触发器里的。select typeid=@typeid from deleted 这句话是什么意思呢，好久都没太明白.deleted是一个表还是什么其它的。


[解决办法]
create trigger delete_employee on employee
for delete
as
declare @typeid varchar(10)
select @typeid =typeid from deleted
delete from loginuser where etypeid=@typeid
go

这个触发器里的。select typeid=@typeid from deleted 这句话是什么意思呢，好久都没太明白.deleted是一个表还是什么其它的。
-----------------------------------------
deleted 是生的一表,束後自除
面的是 表除前的
select @typeid=typeid from deleted
就是把除前的 typeid 值 量 @typeid
建trigger
create trigger delete_employee on employee
for delete
as
delete loginuser from loginuser ,deleted where loginuser.etypeid=deleted.typeid
go


[解决办法]
create trigger delete_employee on employee
for delete
as
declare @typeid varchar(10)
select typeid=@typeid from deleted
delete from loginuser where etypeid=@typeid
go
-----------------------------------------------
应该：
create trigger delete_employee on employee
for delete --在删除表employee里的记录时触发
as
declare @typeid varchar(10)
select @typeid=typeid from deleted --取得删除记录的typeid
delete from loginuser where etypeid=@typeid --删除loginuser表中etypeid=@typeid的记录
go