非常谢谢bqj(听雨)!
我已解决:
我的触发器如下:
CREATE TRIGGER rqtime ON [dbo].[rz]
FOR INSERT, UPDATE
AS
DECLARE @tid int
select @tid=id from inserted
update rz set rz.mdate=rz.mdate + CONVERT(varchar, CONVERT(datetime, getdate()), 108) where id=@tid
再次感谢bqj(听雨),并送上20分!