CREATE TRIGGER [test_Insert] ON [dbo].[MSP_TASKS]
FOR INSERT
AS
Declare @FieldType bit
Declare Cursor cursor1 for select TASK_IS_MILESTONE from MSP_TASKS
Open cursor1
fetch cursor1 into @FieldType
Close cursor1
Create Trigger InsTrigger On Table
For Insert
As
Declare @FieldType int
Declare Cursor cursor1 for select MSP_flag from inserted
Open cursor1
fetch cursor1 into @FieldType
Close cursor1
If @FieldType>0 Then
你的插入执行代码。
End If
create table 表 (a int,b int)
go
insert 表 values (1,2)
go
CREATE TRIGGER 名 ON 表
FOR UPDATE
AS
if update(a)
begin
select a 更新前a被删除的数据 from deleted
select a 更新后a被插入的数据 from inserted
end
if update(b)
begin
select a 更新前b被删除的数据 from deleted
select a 更新后b被插入的数据 from inserted
end
go
------------测试:
update 表 set a=3
-----------------
update 表 set b=4