title: Best practice for concatenation in SQL Server?
body: <p>My row has a NVARCHAR value in a certain column. I want to be able to concatenate onto this value eg, if the row stores "Hello," I want to be able to run a db.Execute command to keep the "Hello" and tag on " my name is Earl" so that "Hello, my name is Earl" is stored in the row.</p>
  
  <p>What is the best practice for doing this?</p>
  
  <pre><code>db.Execute("UPDATE table SET description = description + '--@0 likes this' WHERE id = @1",user, id);
  </code></pre>
  
  <p>This doesnt accept the parameters and actually inserts @0and @1 into the database. Why is this ?</p>