ALTER trigger [del] ON [dbo].[TbStudent]
for delete
as
begin
declare
@ID int,
@userID char(10),
@InTime datetime,
@AssoName nvarchar(50)
select @userID=userID,@AssoName=AssoName,@InTime=InTime from deleted
insert into HisMember(userID,AssoName,InTime) values (@userID,@AssoName,@InTime)
end 本人想再insert 语句中加一个QuitTime 字段 用于存放触发器执行时的当前系统时间 在此谢过
for delete
as
begin
declare
@ID int,
@userID char(10),
@InTime datetime,
@AssoName nvarchar(50)
select @userID=userID,@AssoName=AssoName,@InTime=InTime from deleted
insert into HisMember(userID,AssoName,InTime) values (@userID,@AssoName,@InTime)
end 本人想再insert 语句中加一个QuitTime 字段 用于存放触发器执行时的当前系统时间 在此谢过
FOR DELETE
AS
BEGIN
INSERT INTO HisMember
( userID ,
AssoName ,
InTime ,
QuitTime
)
SELECT userID ,
AssoName ,
InTime ,
GETDATE()
FROM deleted
END
直接這樣就行了