CREATE TRIGGER 插入 ON 表
FOR INSERT
AS
insert northwind..prodcuts select * from inserted
go
CREATE TRIGGER 删除 ON 表
FOR DELETE
AS
delete northwind..prodcuts where 编号 in (select 编号 from deleted)
go
CREATE TRIGGER 修改 ON 表
FOR update
AS
update northwind..prodcuts set 所有列=AA.所有列 from inserted AA where AA.编号=northwind..prodcuts.编号
go
FOR INSERT
AS
insert northwind..prodcuts select * from inserted
go
CREATE TRIGGER 删除 ON 表
FOR DELETE
AS
delete northwind..prodcuts where 编号 in (select 编号 from deleted)
go
CREATE TRIGGER 修改 ON 表
FOR update
AS
update northwind..prodcuts set 所有列=AA.所有列 from inserted AA where AA.编号=northwind..prodcuts.编号
go
解决方案 »
- SQL问题 ,在线等待
- 小问题,问问大家
- case急。。。。
- sql查询:不知道这种情况能不能用sql查询出来?
- 在SQL中调用dll函数时出现的问题
- 求大侠帮忙把下面的SQL语句转换成Access2003数据库语句啊,急用啊
- 如何讓SQLServer 釋放資源?
- SQL Server2005 数据库错误。用的好好的数据库被标可疑。
- 看看我这样调用存储过程是否有问题,急急急,我需要各位的帮助,谢谢!
- SQL2008 Management Studio 不能筛选。。。。无法为该请求检索数据。 (Microsoft.SqlServer.Management.Sdk.Sfc)
- 如何查看到我写的触发器?我想修改它们!
- 打算学习ms sql server,请推荐几本好书.
FOR INSERT,update,deleteselect * from insertedselect * from deleted不知道你说的打印是什么意思,如需要可以插入到某张表中记录下来,再打印CREATE TRIGGER your_trgger ON 表
FOR INSERT,update,deleteinsert into table_bak(col1, col2...)
select 'inserted',* from insertedinsert into table_bak(col1, col2...)
select 'deleted',* from deleted
go
create trigger 表名 on products for insert,update
as
begin
print 'select * from inserted'
end
go
create trigger 表名 on products for delete,update
as
begin
print 'select * from deleted'
end
go
我把语句写成这样,应该也可以吧,请帮我 看看写的对不对,谢谢!