title: i want to pass a select query in a stored procedure as an argumnet
body: <p>I made this procedure..</p>
  
  <pre><code>ALTER PROCEDURE [dbo].[MyProcedure]
              @pSelect nvarchar
  AS
  BEGIN
      SET NOCOUNT ON;
  
      select @pSelect from tabel1
  END
  </code></pre>
  
  <p>I want to pass a select query like from c# code to this stored procedure</p>
  
  <pre><code>MyProcedure("column1,column2");
  </code></pre>
  
  <p>How could I do this because stored procedure treat my parameter as a string and it behaves like</p>
  
  <pre><code>select N'column1,column2' from tabel1
  </code></pre>
  
  <p>pls help me </p>
  
  <p>or provide a better option for this</p>