Oracle触发器 如何改成 SQL Server 触发器

[WangSongYuan]

触发条件怎么改

增、删、改 触发条件sqlserver要创3个吗 ?
after insert
after update
after delete

还有怎么取增、删、改数据的值？

[吉普赛的歌]

IF OBJECT_ID('dbo.testT','U') IS NOT NULL
	DROP TABLE dbo.testT
GO
CREATE TABLE dbo.testT
(
	id INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
	[name] NVARCHAR(20)	NOT NULL
)
GO
CREATE TRIGGER [dbo].[trig_testT_I_D_U]
ON [dbo].testT
AFTER  INSERT, DELETE, UPDATE
AS
BEGIN
	SELECT 'INSERTED' AS FLAG,* FROM INSERTED
	SELECT 'DELETED' AS FLAG,* FROM DELETED
END
GO
INSERT INTO dbo.testT ([name]) VALUES('a')
/*
FLAG	id	name
INSERTED	1	a

FLAG	id	name
*/
INSERT INTO dbo.testT ([name]) VALUES('b')
/*
FLAG	id	name
INSERTED	2	b

FLAG	id	name
*/
UPDATE dbo.testT SET [name]='aa' WHERE id=1
/*
FLAG	id	name
INSERTED	1	aa
FLAG	id	name
DELETED	1	a
*/
DELETE FROM dbo.testT WHERE id=2
/*
FLAG	id	name

FLAG	id	name
DELETED	2	b
*/

[l1314j]

REATE TRIGGER tr
   ON  atd_hr_emp
   AFTER INSERT,DELETE,UPDATE
AS 
BEGIN
	select * From  inserted	
	select * From  deleted		
END
GO

SQL的触发器，是可以写在一个数据表里面的。但是这样写有一个坏处，就是你不是很方便去判断是新增还是修改、删除。理论上，你做好判断就好了，这里是可以这样写的