我有一个表A的,还有一个表B,当我删除A表中的一条记录时,把这条记录添加到表到B中
表A的结构
create table a
(
id varchar(50),
name varchar(50),
password varchar(50)
)
表B的结构
create table b
(
id varchar(50),
name varchar(50),
delu date,//这是登陆时间
zhangtai varchar(2) 登陆状态
)
表A的结构
create table a
(
id varchar(50),
name varchar(50),
password varchar(50)
)
表B的结构
create table b
(
id varchar(50),
name varchar(50),
delu date,//这是登陆时间
zhangtai varchar(2) 登陆状态
)
where id = object_id(N'[dbo].[Tr_name]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Tr_name]
GO
CREATE TRIGGER Tr_name ON A
FOR delete AS
insert into B(ID,Name) select ID,Name from deleted
GO
create or replace trigger deleteInfoSite
after delete on shwz.test_site
for each row
declare
-- local variables here
begin
IF DELETING AND (:old.site_name IS NOT NULL) THEN
insert into shwz.shwz_site(site_name,site_url,site_address,site_person,site_phone,
site_icp,site_content,site_news,site_bbs,site_foreign,site_scale,site_class,site_bz,
site_fw,site_wzc,site_ip,site_serveradd,site_district,SITE_ROAD,site_doornum,SITE_EDITID )
values (:old.site_name,:old.site_url,:old.site_address,:old.site_person,
:old.site_phone,:old.site_icp,:old.site_content,:old.site_news,:old.site_bbs,
:old.site_foreign,:old.site_scale,:old.site_class,:old.site_bz,:old.site_fw,
:old.site_wzc,:old.site_ip,:old.site_serveradd,:old.site_district,:old.SITE_ROAD,
:old.site_doornum,siteID.Nextval) ;
end if;
end ;
if exists (select * from dbo.sysobjects
where id = object_id(N'[dbo].[Tr_name]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Tr_name]
GO
CREATE TRIGGER Tr_name ON A
FOR delete AS
insert into B(ID,Name,Delu,Zhuangtai)
select ID,Name from deleted a,yourtable b
where a.id = b.id
GO
“http://192.9.168.2/20061121/Manager.jsp?id=<%=get.getID()%>”