title: How to put variables in a SQL Server comment?
body: <p>Sadly, we do auditing through inline comments in SQL queries, like this: </p>
  
  <pre><code>begin transaction; 
  EXEC someStoredProcedure; --this was executed by Bob
  commit transaction;
  </code></pre>
  
  <p>I'm trying to automate it by making a tool with user inputted fields. Is there any way to make strings in a comment variable, like this?</p>
  
  <pre><code>DECLARE @username varchar(50);
  
  begin transaction; 
  EXEC someStoredProcedure; --this was executed by @username
  commit transaction;
  </code></pre>