sqlserver 触发器

IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE XTYPE = 'TR' AND NAME = 'insertajfkdate')
DROP TRIGGER insertajfkdate
GO
CREATE TRIGGER insertajfkdate
ON s_getin
FOR INSERT
AS
--提交事务处理
BEGIN TRANSACTION
--强制执行下列语句，保证业务规则
UPDATE s_room
SET  s_room.ajfkdate=t.[getdate]
From (select [getdate] from s_getin)  as t  
Where s_room.roomno=t.[getdate]
COMMIT TRANSACTION
GO