CREATE VIEW [dbo].[VObjHuman]
AS
SELECT        dbo.ObjHuman.ObjectID, dbo.ObjHuman.FirstName, dbo.ObjHuman.MiddleName, dbo.ObjHuman.LastName, dbo.ObjHuman.SexID, dbo.ObjHuman.BirthDay, dbo.ObjHuman.BirthPlace, dbo.ObjHuman.NationalityID, 
                         dbo.ObjHuman.CitizenshipID, dbo.Object.ObjectNameID, dbo.Object.Qualify, dbo.Object.CreateDate, dbo.Object.ModifyDate, dbo.Object.Creator, dbo.Object.Editor
FROM            dbo.Object INNER JOIN
                         dbo.ObjHuman ON dbo.Object.ObjectID = dbo.ObjHuman.ObjectID

CREATE TRIGGER [dbo].[updVObjHuman] ON [dbo].[VObjHuman]
instead of update
as 
begin
 set nocount on 
 update ObjHuman
 set ObjHuman.FirstName=Inserted.FirstName, 
     ObjHuman.MiddleName=Inserted.MiddleName, 
	 ObjHuman.LastName=Inserted.LastName, 
	 ObjHuman.SexID=Inserted.SexID, 
	 ObjHuman.BirthDay=Inserted.BirthDay, 
	 ObjHuman.BirthPlace=Inserted.BirthPlace, 
	 ObjHuman.NationalityID=Inserted.NationalityID, 
	 ObjHuman.CitizenshipID=Inserted.CitizenshipID
 from Inserted where ObjHuman.ObjectID = Inserted.ObjectID	  
 update Object
 set Object.Qualify=Inserted.Qualify, 
	 Object.ModifyDate=GetDate(), 
	 Object.Editor=system_user  
 from Inserted where Object.ObjectID = Inserted.ObjectID	   
end

CREATE TRIGGER [dbo].[updVObjHuman] ON [dbo].[VObjHuman]
after update
as 
begin
 set nocount on 
 update VObjHuman
 set VObjHuman.ModifyDate=GetDate(), 
	 VObjHuman.Editor=system_user  
 from Inserted where VObjHuman.ObjectID = Inserted.ObjectID	 
end