Home Forums SQL Server 2012 SQL Server 2012 - T-SQL sp_send_dbmail question RE: sp_send_dbmail question
Eirikur Eiriksson
SSC Guru
Points: 182882
More actions
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;