This project demonstrates the use of various SQL Server window functions in an existing database context. Window functions provide powerful capabilities for analyzing and reporting on data, such as ...

For example, you can use the MD5() function in MySQL or the HASHBYTES() function in SQL Server to create a hash of a password and store it in the database instead of the plain text.

See Walkthrough: Creating and Running a SQL Server Unit Test for an example of adding a unit test for a stored procedure, in the "To create a SQL Server unit test for the stored procedures" section..