Most programming languages have the ability to interpolate formatted strings. For example, in C#

String input = String.Format("oh hi {0}", "mike");

This is also possible in T-SQL through the use of two functions.

In SQL Server 2008 the function  was introduced

Also, in SQL Server 2012 the  function was added.

 

两个单引号，会转义为一个单引号

SELECT   FORMATMESSAGE(             'exec pi_NoUseWebpartReplacement @Id = %s,@Category = ''%s'',@WebpartCode = ''%s'',@WebpartName = ''%s'',@WebpartFile = ''%s'',@Replacement = ''%s''' ,             CONVERT(NVARCHAR(255), Id),             Category ,             WebpartCode ,             WebpartName ,             WebpartFile ,             Replacement)FROM     dbo.LISA_NoUseWebpartReplacementORDER BY Id;