CREATE TABLE my_table*
(a int NULL, b int NULL)
GOCREATE TRIGGER my_trig
ON my_table
FOR INSERT,UPDATE
AS
IF UPDATE(b)
PRINT 'Column b Modified'
GO
INSERT INTO MY_TABLE(A) VALUES(2)
-----------------------------------------------
为什么插入A也会 PRINT 'Column b Modified' 呢?
我想判断B列在INSERT后是否有值插入,有什么办法实现???
谢谢!
(a int NULL, b int NULL)
GOCREATE TRIGGER my_trig
ON my_table
FOR INSERT,UPDATE
AS
IF UPDATE(b)
PRINT 'Column b Modified'
GO
INSERT INTO MY_TABLE(A) VALUES(2)
-----------------------------------------------
为什么插入A也会 PRINT 'Column b Modified' 呢?
我想判断B列在INSERT后是否有值插入,有什么办法实现???
谢谢!
ON my_table
FOR INSERT,UPDATE
AS
IF UPDATE(b) and exists(select * from deleted)
PRINT 'Column b Modified'
GO
CREATE TRIGGER my_trig
ON my_table
FOR UPDATE
AS
IF UPDATE(b)
PRINT 'Column b Modified'
GO
-- 可以这样, 增加触发的是否update操作的判断CREATE TRIGGER my_trig
ON my_table
FOR INSERT,UPDATE
AS
IF UPDATE(b) and exists(select * from deleted)
PRINT 'Column b Modified'
GO
-----------------------------------------看不懂哦,好像insert哪列都不出现了!