MD5 Hash Function Exist in SQL

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Kenneth Wilhelmsson SSC-Dedicated Points: 30043 More actions · Answer 1

I would guess the answer is no.

SQL Server has no supported encryption functions that I know of

/Kenneth

jordanac Hall of Fame Points: 3653 More actions · Answer 2

There are PWDENCRYPT and PWDCOMPARE functions...

Declare @pswrd varbinary(255),

@Authorized int

select @pswrd = PWDENCRYPT('Hello')

SELECT @Authorized = PWDCOMPARE ('Hello',(@pswrd ),0)

if @Authorized = 0 print 'Get Lost!!@#'

if @Authorized = 1 print 'PLEASE COME IN'

Andy.

Kenneth Wilhelmsson SSC-Dedicated Points: 30043 More actions · Answer 3

There is, but those are undocumented and highly unsupported for 'user' usage.

/Kenneth

millersmith Grasshopper Points: 21 More actions · Answer 4

I ran across this the other day and it works great thus far.

Arkadiusz Pieczykolan SSC Enthusiast Points: 113 More actions · Answer 5

I found only 2 solutions:

Arek