title: How to make stored procedure dynamic search with SQL Server
body: <p>How to make stored procedure dynamic search with <code>SQL Server</code> with name table and name filed and value filed</p>
  
  <pre><code>select * from @nametable where @filedname = @valuename
  </code></pre>