update t
set [date] = getdate()
from Inserted i
      inner join таблица t on t.ID = i.ID

CREATE TRIGGER t5
ON dbo.Shop
FOR UPDATE

AS
DECLARE @ID int, @name nvarchar(150)

DECLARE CUR1 CURSOR FOR 
	SELECT Shop_ID FROM inserted 

OPEN CUR1
	FETCH NEXT FROM CUR1 INTO @ID
	  WHILE @@FETCH_STATUS=0
		BEGIN 
		  UPDATE Shop SET Shop_DataTime=SYSDATETIME() 
		   WHERE Shop_ID=@ID
	        FETCH NEXT FROM CUR1 INTO @ID
      
          		END
CLOSE CUR1

DEALLOCATE CUR1 

update t
set [date] = getdate()
from Inserted i
      inner join таблица t on t.ID = i.ID

update t
set [date] = getdate()
from Inserted i
      inner join таблица t on t.ID = i.ID
where not exists(select i.[ID],i.[Name] intersect select t.[ID],t.[Name])