Trigger questions - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Trigger questions

Trigger questions# Database - 数据库

k*r2004-12-15 08:12

1 楼

I want to write a trigger. Whenever someone tries to delete the rows of a
table, then the trigger will be fired and those deleted rows will be inserted
into a temp table. In addition, the temp table also need a column to record
the date and time when each row is deleted. Please give me some advices.
Thanks a lot!

aw2004-12-15 08:12

2 楼

if you're using SQL Server.
CREATE TRIGGER [TRIGGER NAME] ON [table_name]
FOR DELETE
AS
INSERT INTO TEMP_TABLE
SELECT *, current_timestamp FROM Deleted
Deleted is a system virtual table in SQL server.

inserted

【在 k******r 的大作中提到】

: I want to write a trigger. Whenever someone tries to delete the rows of a
: table, then the trigger will be fired and those deleted rows will be inserted
: into a temp table. In addition, the temp table also need a column to record
: the date and time when each row is deleted. Please give me some advices.
: Thanks a lot!

k*r2004-12-15 08:12

3 楼

Thanks a lot!

record

【在 aw 的大作中提到】

: if you're using SQL Server.
: CREATE TRIGGER [TRIGGER NAME] ON [table_name]
: FOR DELETE
: AS
: INSERT INTO TEMP_TABLE
: SELECT *, current_timestamp FROM Deleted
: Deleted is a system virtual table in SQL server.
:
: inserted