title: What is the SQL Server equivalent of Oracle bind variables in dynamic SQL?
body: <p>In Oracle, when writing dynamic SQL one does something like this:</p>
  
  <pre><code>create or replace procedure myProc(n in number)
  as
  begin
    execute immediate
     'update myTable set myColumn = :n' 
     using n;
  commit;
  end;
  </code></pre>
  
  <p>And then 'magic happens'. What, if any, is the equivalent concept / syntax in SQL Server? (BTW I'm using SQL Server 2005)</p>