search

fjtello / SQL-C-sharp

Common programming and coding tips and howtos
0 stars 0 forks source link

SQL password hashbytes sha2_512 varbinary(128) #46

Open fjtello opened 5 years ago

fjtello commented 5 years ago

Client.Password => varbinary(128)

declare @password as varchar(128); set @password = 'Password';

insert into Client (Document, Password) values ('23000000T', HASHBYTES('SHA2_512', @password));

select * from Client where Password = HASHBYTES('SHA2_512', @password);