xxxxxxxxxx
CREATE TRIGGER [dbo].[CustomersUpdateTrigger]
ON [dbo].[Customers]
AFTER UPDATE
AS
BEGIN
IF UPDATE(LastName)
PRINT 'UPDATE(LastName)'
IF ( COLUMNS_UPDATED () & 1 = 1 )
PRINT 'COLUMNS_UPDATED ( ) & 1'
IF EXISTS(SELECT LastName
FROM inserted)
PRINT 'EXISTS(SELECT LastName FROM inserted)'
END