有个问题...

[麦子VISA]

CREATE TRIGGER [TRI_UPDATE] ON [dbo].[T_TelAlarmInfo]
FOR INSERT
AS BEGIN
DECLARE @ID nvarchar
SELECT @ID=ClusterID FROM INSERTED
UPDATE T_TelAlarmInfo SET EffectFlag='未定' where ClusterID=@ID
END

---------------------
这个触发器是想实现插入数据时更新它的NULL字段，可是没有成功，把 where ClusterID=@ID
条件去掉后能将所有记录更新，问题象是@ID没有获得相应的值，我错在哪里？正确的该怎么做呢？

谢谢

[麦子VISA]

ClusterID 是我表的主键

[paoluo]

CREATE TRIGGER [TRI_UPDATE] ON [dbo].[T_TelAlarmInfo]
FOR INSERT
AS
UPDATE A SET EffectFlag='未定' from T_TelAlarmInfo A Inner Join INSERTED B On A.ClusterID=B.ClusterID
GO