title: How do I hash the admin password in my Users table?
body: <p>How do I hash the admin password in my Users table?</p>
  
  <p>Using SQL Server 2008 R2</p>
  
  <p>I know there is an encryption command is built into PHP but I'm not sure if this is possible using an SQL query. </p>
  
  <p>Example: Table called users, with entry of admin, password is <code>sha1('password')</code></p>