title: Incorrect syntax near '<'. The label 'xmlns' has already been declared. Label names must be unique within a query batch or stored procedure
body: <p>I am getting a string from a database that is in xml format and trying to update the xml with the following query:</p>
  
  <pre><code>ExecuteNonQuery("Update Logs SET Message = " + encryptedMessage + " WHERE ID = " + message.Id);
  </code></pre>
  
  <p>but it gives me the error message:</p>
  
  <p><code>Incorrect syntax near '&lt;'.
  The label 'xmlns' has already been declared. Label names must be unique within a query batch or stored procedure.
  An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
  An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
  An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
  An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
  An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.</code></p>
  
  <p>I have a feeling it might have something to do with the quotes, but I am not sure.  I have tried different options like single quotes, mixture,etc.</p>
  
  <p>For example, if I do:</p>
  
  <pre><code>ExecuteNonQuery("Update Logs SET Message = " + encryptedMessage.Replace('"','\'')+ " WHERE ID = " + message.Id);
  </code></pre>
  
  <p>Would this permanently update the double quotes in the message to single quotes.  I don't want to do this.</p>