CREATE TRIGGER update_trig ON [RM].[ReadRoom1]
FOR UPDATE
AS
declare @fdo char(20)
declare @nfdo char(20)
UPDATE Querrynote1
select @fdo=ReadRoomName from deleted
select @nfdo=ReadRoomName from inserted
exec sp_rename @fdo,@nfdo
END
FOR UPDATE
AS
declare @fdo char(20)
declare @nfdo char(20)
UPDATE Querrynote1
select @fdo=ReadRoomName from deleted
select @nfdo=ReadRoomName from inserted
exec sp_rename @fdo,@nfdo
END
在关键字 'declare' 附近有语法错误
declare错误没有了,但是又出现select附近有语法错误
UPDATE Querrynote1
set 字段1=(select @fdo=ReadRoomName from deleted where ...) where ...
set 字段2=(select @nfdo=ReadRoomName from inserted where ...) where ...
exec sp_rename @fdo,@nfdo