Триггеры

/****** Object:  Trigger [dbo].[Client_insert]    Script Date: 04.03.2015 13:15:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[Client_insert]    
   ON  [dbo].[Client]    
   INSTEAD OF INSERT
AS 
BEGIN
    SET NOCOUNT ON;
    DECLARE cur CURSOR FOR
        SELECT [fio],[series_document],[number_document] FROM inserted
    OPEN cur
    DECLARE @fio VARCHAR(100)
    DECLARE @series_document INT
    DECLARE @number_document INT
    DECLARE @id_document INT
    --select @fio = fio from inserted
    --Select @series_document = series_document from inserted where fio = @fio
    --Select @number_document = number_document from inserted where fio = @fio
    --Select @id_document = number_document from inserted where fio = @fio
    FETCH NEXT FROM cur
            INTO @fio,@series_document,@number_document, @id_document
    WHILE @@FETCH_STATUS = 0
    BEGIN
            IF EXISTS (SELECT id FROM [Client] WHERE fio = @fio AND series_document = @series_document AND number_document =@number_document AND id_document=@id_document)
            BEGIN 
                RAISERROR ('Такой клиент уже есть в базе', 16, 1)
                ROLLBACK TRANSACTION
            END
            ELSE
                BEGIN
                INSERT INTO dbo.[Client](fio,series_document,number_document,id_document)
                VALUES(@fio, @series_document, @number_document  ,@id_document)
                END
    FETCH NEXT FROM cur
        INTO @id_stadion,@dataVremya,@id_tyr,@id_document
    END
    CLOSE cur
    DEALLOCATE cur
END

/****** Object:  Trigger [dbo].[empl_update]    Script Date: 04.03.2015 13:15:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[empl_update] 
   ON  [dbo].[Employees]
   INSTEAD OF UPDATE
AS 
BEGIN
    SET NOCOUNT ON;
    DECLARE @id INT
    DECLARE @fio datetime
    DECLARE cur CURSOR FOR
        SELECT * FROM INSERTED
    OPEN cur
    SELECT @id= id FROM inserted
    FETCH NEXT FROM cur
        INTO @id, @fio
    WHILE @@FETCH_STATUS = 0
    IF EXISTS(SELECT id FROM Employees WHERE fio=@fio)
        BEGIN
            RAISERROR ('Такой сотрудник уже принят на работу', 16, 1)
            ROLLBACK TRANSACTION
        END
    ELSE
    BEGIN
            UPDATE Employees SET fio=@fio WHERE [id]=@id
            FETCH NEXT FROM cur
                INTO @id, @fio
        END
    CLOSE cur
    DEALLOCATE cur
END