Quote Originally Posted by sapator View Post
Thanks.
Actually this: IF INSERTED.person_password<>COALESCE(DELETED.person_password, '') should be enough, provided person_password is NOT NULL
Will not compile it says column cannot be found, I have to go like set @i = (SELECT i.person_password FROM INSERTED i)
Don't know if it works for other database types.
Ah, ok. Might be.
i‘m not that familiar with MSSQL