Home Forums SQL Server 2012 SQL Server 2012 - T-SQL sp_send_dbmail question RE: sp_send_dbmail question

  • July 30, 2014 at 2:23 pm

    #1733814

    Quick suggestion, if you are on SQL 2012 or later, use the concat function.

    😎

    DECLARE @recordcount INT = 007;

    DECLARE @mysubject varchar(500) = CONCAT('Number of unprocessed records on SQL1 ',@recordcount);

    SELECT @mysubject;