title: How to specify a table dynamically in a Stored Procedure
body: <p>Thanks for the feedback, but I was hoping for help with an UPDATE command, not SELECT.
  Can anyone help with the syntax for an UPDATE command?</p>
  
  <p>I am passing a table name into a Stored Procedure but the SQL does not seem to recognize it.</p>
  
  <pre><code>DECLARE @userTable AS VARCHAR(200);
  SET @userTable = @currTable
  
  
  UPDATE @userTable
  SET     [lang_String] = @lang_String, [date_Changed] = @submitDate1
  WHERE   (ID = @ID)
  </code></pre>
  
  <p><code>@currTable</code> is passed into the Stored Procedure. All tables names are built by design in code.</p>