Category Archives: SQL

Hashbytes in SQL Server returns different value for different data type

If you are using Hashbytes ‘SHA1’ or ‘MD5’ algorithm for your password field make sure you are not changing database in insert procedure and select procedure otherwise you will not be able to find any error and also won’t be … Continue reading

SQL Server – LTRIM() and RTRIM() Functions

Usage : The TRIM function in SQL is used to remove specified prefix or suffix from a string. This is the most common pattern to remove white spaces. Syntax : LTRIM(str): Removes all white spaces from the beginning of the … Continue reading