title: Encrypted query in sql server
body: <p>I want to execute a query in our client's server using remove access. If I execute a query something like this <code>Update abc set col1=12 where id = 2</code> they will understand what we are doing. So I want some method for encryption and decryption like this:</p>
  
  <p>In our server I encrypt a query like this:</p>
  
  <pre><code>encrypt(Update abc set col1=12 where id = 2)
  </code></pre>
  
  <p>So I get output like:</p>
  
  <blockquote>
    <p>0x0100CF465B7B12625EF019E157120D58DD46569AC7BF4118455D12625EF019E157120D58DD46569AC7BF4118455D</p>
  </blockquote>
  
  <p>And I execute a this encrypted query on client's machine like this:</p>
  
  <p><code>
  decrypt(0x0100CF465B7B12625EF019E157120D58DD46569AC7BF4118455D12625EF019E157120D58DD46569AC7BF4118455D)
  </code></p>
  
  <p>So our client can't understand what we have executed.</p>