drop trigger PassengerUpdate
go

create trigger PassengerUpdate
on Passengers
for update
as
declare @Passport int
select @Passport = i.Passport from inserted i;
begin
	if @Passport =  @Passport 
	begin
		print 'При смене фамилии не был изменён номер паспорта'
		rollback tran
	end
end
go

select * from Passengers

update Passengers
set Passport = 2222
where Full_Name = 'Петров Пётр Петрович'

SELECT * FROM  inserted

if @Passport =  @Passport 

drop trigger PassengerUpdate
go

create trigger PassengerUpdate
on Passengers
for update
as
declare @Passport int
select @Passport = i.Passport from inserted i;
begin
	if @Passport <0 or  @Passport >9999
	begin
		print 'Недопустимый номер пасспорта'
		rollback tran
	end
end
go

select * from Passengers

update Passengers
set Passport = 3333
where Full_Name = 'Петров Пётр Петрович'

select @Passport = i.Passport from inserted i;

ALTER TRIGGER PassengerUpdate
   ON  Passengers
   FOR UPDATE
AS 
BEGIN
	SET NOCOUNT ON
	IF UPDATE(Full_Name) AND EXISTS(SELECT * FROM Deleted d INNER JOIN Inserted i ON d.id = i.id AND d.Passport = i.Passport AND NOT d.Full_Name = i.Full_Name)AND NOT d.Full_Name = p.Full_Name)
		BEGIN
			RAISERROR ('При смене фамилии не был изменён номер паспорта', 16, 1);  
			ROLLBACK TRANSACTION
		END

END
GO
	
SELECT * FROM Passengers

UPDATE Passengers
		SET Full_Name =CONVERT(varchar,GETDATE(),113)
			,Passport= 23
	WHERE id=1

SELECT * FROM Passengers

	IF UPDATE(Full_Name) AND EXISTS(SELECT * FROM Deleted d INNER JOIN Inserted i ON d.id = i.id AND d.Passport = i.Passport AND NOT d.Full_Name = i.Full_Name)