sql update触发器错误



USE [WorkFlow]
GO
/****** Object:  Trigger [dbo].[WorkflowInstanceStart]    Script Date: 2014/6/16 17:11:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:  <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER TRIGGER [dbo].[WorkflowInstanceStart]
   ON  [dbo].[WorkflowInstanceStartUp]
FOR UPDATE
AS
DECLARE @oldid varchar(100)
DECLARE @old1 varchar(100)
DECLARE @d int
DECLARE @dd int
 SELECT @oldid=WoflInsSU_Id FROM inserted
 SELECT @old1=WoflInsSU_Startid FROM inserted
 SELECT IDENT_CURRENT('Workflow_Log') from Workflow_Log
 SELECT @dd=MAX(Id) from dbo.Workflow_Log
 SELECT @d=COUNT(IDENT_CURRENT('Workflow_Log')) from Workflow_Log
 IF (@d=1)
 BEGIN
 UPDATE dbo.Workflow_Log SET StartUp_Id=@oldid WHERE Id=IDENT_CURRENT('Workflow_Log')
 UPDATE dbo.Workflow_Log SET Perform_Id=@old1 WHERE Id=IDENT_CURRENT('Workflow_Log')
 END
 ELSE
BEGIN
 WHILE (@d>0)
 BEGIN
 SET @d=@d-1
 UPDATE dbo.Workflow_Log SET StartUp_Id=@oldid WHERE Id=@dd
 UPDATE dbo.Workflow_Log SET Perform_Id=@old1 WHERE Id=@dd
 SET @dd=@dd-1
 END
END

求大神解答，哪里错了，不能正常修改啊