CREATE TRIGGER [Trg_Log_insert] ON [dbo].[Tbl_PreOrderD]
FOR INSERT
AS
begin
insert into tbl_log (tblname,operate,staffid,location,logtime)
select 'Tbl_PreOrderD','insert',ins.staffID,ins.ID,getdate()
from inserted ins
end
FOR INSERT
AS
begin
insert into tbl_log (tblname,operate,staffid,location,logtime)
select 'Tbl_PreOrderD','insert',ins.staffID,ins.ID,getdate()
from inserted ins
end
CREATE TRIGGER [Trg_Log_insert] ON [dbo].[Tbl_PreOrderD]
FOR INSERT
AS
begin
a=(select ins.[staffID] from inserted ins)
b=(select ins.[ID] from inserted ins)
c=(select getdate())
insert into tbl_log (tblname,operate,staffid,location,logtime)
values ('Tbl_PreOrderD','insert',a,b,c)
end
出错了,是不是因为不能定义变量的?
insert--->after insert the record, you can use inserted.
delete--->after delete ther record,you can use deleted.
update-->deleted,inserted3.
CREATE TRIGGER [Trg_Log_insert] ON [dbo].[Tbl_PreOrderD]
FOR INSERT
AS
begin
declare @a vachar(10)
declare @b vachar(10)
declare @c vachar(10)select @a=ins.[staffID] from inserted ins
select @b=ins.[ID] from inserted ins
set @c=getdate()
insert into tbl_log (tblname,operate,staffid,location,logtime)
values ('Tbl_PreOrderD','insert',@a,@b,@c)
end