Hash Password by Trigger SQL SERVER

sql

-- trigger trên table USER
create trigger [dbo].[trg_AutoCryptPassword] on [dbo].[USER]
for insert, update
as
begin
	if UPDATE([Password])
	begin
		declare @id int
		declare @Password varchar(256)
		select @Password = [Password], @id = IdUser from inserted
		set @Password = dbo.func_CryptData(@Password)
		update [USER] set [Password] = @Password where IdUser = @id
	end
end

-- hàm hash
create function [dbo].[func_CryptData] (@Data varchar(100))
returns varchar(256)
as
begin
return convert(varchar(256),HASHBYTES('SHA2_256',@Data),2)
end