create trigger tri_title_id
on Sales
for insert,update
as
declare @ID int
select @id=title_id from Inserted
if exists(select * from Sales where title_id=@id)
begin
insert inito Sales select * from Inserted
end
gocreate trigger tri_Stores
on Stores
for delete
as
insert inito Sales_old select * from deleted
go
on Sales
for insert,update
as
declare @ID int
select @id=title_id from Inserted
if exists(select * from Sales where title_id=@id)
begin
insert inito Sales select * from Inserted
end
gocreate trigger tri_Stores
on Stores
for delete
as
insert inito Sales_old select * from deleted
go
解决方案 »
- 如何把一个存贮过程的值放入到一个临时表里。
- 求SQL:log表中每天得分最高的前10名
- 如何把sql server 2000中northwind数据库导入到sql server 2005中?
- 对于淘宝网中好评率的设计
- MSSQL 中请问如何将一字段值分割 然后as 成新字段值呢?谢谢
- Microsoft SQL Server 2005 安装程序出错!
- SQL一行转换成多行
- 存储过程能跨数据库创建吗?
- 在MSSQL里一个字段的描述信息能取出来吗!
- 高分求教 C(Sql Server 7.0)/S 结构中:C端的配置、S端的配置以及PROXY的创建。目前最高能给56分,先给50,解决后再加150分。
- 如何才能知道哪個用戶占用SQL的資源最多?
- 想给每条记录加个序号
on Sales
instead of insert,update
as
declare @ID int
select @id=title_id from Inserted
if exists(select * from Sales where title_id=@id)
begin
insert inito Sales select * from Inserted
end
create trigger tri_Stores
on Stores
for delete
as
insert into Sales_old select * from deleted
go
go
on Sales
instead of insert,update
as
declare @ID int
select @id=title_id from Inserted
if exists(select * from Sales where title_id=@id)
begin
insert into Sales select * from Inserted
end
这个Inserted是什么,是表名吗,可是上面没有提到呀