E
exceed
Unregistered / Unconfirmed
GUEST, unregistred user!
当我同时更新多条数据时,触发器只响应部分更新的数据
CREATE TRIGGER sendinf ON [dbo].[msg]
FOR UPDATE
AS
DECLARE @userid varchar(20),@sql varchar(300)
SELECT @userid=sender FROM deleted
SET @userid='INF '+@userid
SET @sql='master..xp_cmdshell ''oanews '+@userid+' '' '
EXECUTE (@sql)
CREATE TRIGGER sendinf ON [dbo].[msg]
FOR UPDATE
AS
DECLARE @userid varchar(20),@sql varchar(300)
SELECT @userid=sender FROM deleted
SET @userid='INF '+@userid
SET @sql='master..xp_cmdshell ''oanews '+@userid+' '' '
EXECUTE (@sql)