title: Set encryption per parameter
body: <p>i'm new to T-SQL and i got the following question:</p>
  <p>Is it possible to set the encryption per parameter? Something like this: (pseudo code)</p>
  <pre><code>create or alter procedure [db].[my_new_proc]
     @Parameter1 int
     @Parameter2 int
     @ParEncryptYN bit
  
  if @ParEncryptYN = 1
    AS
  else
    WITH ENCRYPTION AS
  end
  begin
  ...
  end
  </code></pre>
  <p>I know that i can't use if there, thats why i'm asking.</p>
  <p>Any help is appreciated. Thanks.</p>