/*环境:SQL SERVER 2008 EXPRESS*/
---------------------------------------------------------------
SET
NOCOUNT ON
CREATE
TABLE Source (Sou_ID int IDENTITY, Sou_Desc varchar(10))
GO
IF
OBJECT_ID ('tr_Source_INSERT', 'TR') IS NOT NULL
DROP TRIGGER tr_Source_INSERT;
GO
CREATE
TRIGGER tr_Source_INSERT
ON
Source
FOR
INSERT
AS
GETDATE()
GO
INSERT
Source (Sou_Desc) VALUES ('Test 1')
步骤:
1)安装以上环境+管理工具
2)打开一个query窗口,copy and paste 以下语句
3)运行
/*
* 关于object的链接如下
* http://msdn.microsoft.com/en-us/library/ms190324.aspx
*/