呵呵,还有,触发器在SQL Server的哪里写呀?是不是在“存储过程”那里写呀?是不是新建一个存储过程,但把他写成“create trigger myTrigger on myTable...”就行了? 初次接触触发器,不是很懂
呵呵……初学SQL,献丑一下USE TableB GO CREATE TRIGGER T1 ON TableA FOR INSERT, DELETE AS BEGIN UPDATE TableB SET TableB.fieldName = ( SELECT COUNT(*) FROM tableA ) END
初次接触触发器,不是很懂
GO
CREATE TRIGGER T1
ON TableA
FOR INSERT, DELETE
AS
BEGIN
UPDATE TableB
SET TableB.fieldName = (
SELECT COUNT(*)
FROM tableA )
END