title: How to reference parameter values in the email body using sp_send_dbmail
body: <p>I am trying to include a parameter value in the email body but not sure how to do it.  I have declared the parameters and i want to use the SHIFT_START and SHIFT_END in the email body. For example:</p>
  
  <pre><code>declare @Emails   nvarchar (100)
      declare @FullName  nvarchar (100)
      declare @ShiftStart  nvarchar (50)
      declare @ShiftEnd  nvarchar (50)
  
      DECLARE @EmailBody  VARCHAR(1000)
     set @EmailBody = N'&lt;H1&gt;Hello:&lt;/H1&gt;' +
     N'you have indicated that your shift start was "PARAMETER VALUE HERE" and your shift end was "PARAMETER VALUE HERE" ' +
              N'&lt;br&gt;Please make sure.........' +
              N'&lt;br&gt;Thank You' +
  </code></pre>