title: Encrypting a password column
body: <p>I have a database table that looks like this (simplified):</p>
  
  <pre><code>CREATE TABLE  User 
  (
       ID int, 
       UserName varchar(100), 
       password varchar(100), 
       primary key (ID)
  )
  </code></pre>
  
  <p>I want to encrypt the <code>password</code> column. I have looked into TDS (Transparent Data Encryption) and it appears that you can encrypt databases and columns at the file level.</p>
  
  <p><strong>If I use this approach then will people see the password if they run the following query:</strong></p>
  
  <pre><code>select password from [User]
  </code></pre>
  
  <p>The database runs on SQL Server 2012 Enterprise Edition.</p>