How to generate hexadecimal number for files and store them in table with file name like MD5 do?
I want to check application files that these are correct or not through SQL code , I know about MD5 that we can generate hexadecimal number through MD5 and then check if any mismatch but I want to implement this through SQL code. I will store correct file version in database table and for checking purpose on application lo-gin I will check these version with existing application file version. Also suggest that this will be current approach or not. Please suggest something?
You could use the [HASHBYTES()] function to create an MD5 hash of a value to check against. However, I can't understand why you'd want to do that in T-SQL instead of in the client software (that is where you are wanting to do the check anyway if I understand correctly). :