22,209
社区成员
发帖
与我相关
我的任务
分享
create trigger my_trig on My_table
instead of insert
as
Create table My_Table (a int null,b int null)
go
create trigger my_trig on My_table
for
insert
as
if update(b)
begin
insert my_table values(1,2)
print'OK!'
end
go
insert my_table values(1,2)
select * from My_Table