請問一下，下面的Trigger找到了n筆的資料，該怎麼一筆一筆的將資料塞到另一個資料表當中？ CREATE TRIGGER triTest ON dbo.Test FOR UPDATE AS DECLARE @tmpTestid int, @tmpTestName VARCHAR(20), @tmpState CHAR(1) BEGIN TRANSACTION SELECT @tmpState = state FROM inserted IF @tmpState = 'D' THEN BEGIN SELECT @tmpTestid = Testid, @tmpTestName = TestName, @tmpState = State FROM deleted INSERT INTO Test_audit VALUES(@tmpTestId, @tmpTestName, @tmpState) END COMMIT TRANSACTION GO 我降子寫，如果下SQL指令一次更新許多筆紀錄的話，此Trigger只會觸發一次，該怎樣寫才會觸發多次呢？謝謝～～～

我覺得你需要使用游標，以下是我寫一個觸發器，供參考： create trigger tr_porate on po with encryption for insert,update as --匯率設置觸發器 begin declare @mater_no varchar(14), @rate real, @sn int declare cur_getrate scroll cursor for select rate from exchange open cur_getrate fetch cur_getrate into @rate close cur_getrate deallocate cur_getrate declare cur_po scroll cursor for select mater_no,sn_no from po open cur_po fetch cur_po into @mater_no,@sn while (@@fetch_status=0) begin update po set rate=@rate where sn_no=@sn and ratemark='yes' update po set rate=1 where sn_no=@sn and ratemark='no' fetch cur_po into @mater_no,@sn end close cur_po deallocate cur_po return end go 努力过，还有什么遗憾呢!

試試看:

...
  IF @tmpState = 'D' THEN
  BEGIN
      INSERT INTO Test_audit
      SELECT Testid,TestName,State
      FROM deleted
  END
... 

發表人 - Mickey 於 2004/05/06 20:43:43

引言: 試試看:

...
  IF @tmpState = 'D' THEN
  BEGIN
      INSERT INTO Test_audit
      SELECT Testid,TestName,State
      FROM deleted
  END
... 

發表人 - Mickey 於 2004/05/06 20:43:43

版主的方法比較簡單可行唷~~ 謝啦~~ 也謝謝danielldf大大的解答唷~~