CREATE TRIGGER InsertToSendQueue ON [dbo].[SendMessage]
FOR INSERT
AS
SET NOCOUNT ON
INSERT INTO SendMessageQueue SELECT * FROM Inserted
SET NOCOUNT OFF
该存储过程是一个表SendMessage的触发器,在Insert时触发,将把插入用的缓存表(Inserted)中的所有列复制到SendMessageQueue表中
SET NOCOUNT {ON | OFF} 使返回的结果中不包含有关受SQL语句影响的行数信息。为ON时,不返回计数,为OFF时,返回计数。
FOR INSERT
AS
SET NOCOUNT ON
INSERT INTO SendMessageQueue SELECT * FROM Inserted
SET NOCOUNT OFF
该存储过程是一个表SendMessage的触发器,在Insert时触发,将把插入用的缓存表(Inserted)中的所有列复制到SendMessageQueue表中
SET NOCOUNT {ON | OFF} 使返回的结果中不包含有关受SQL语句影响的行数信息。为ON时,不返回计数,为OFF时,返回计数。