FORMATMESSAGE Function in SQL Server 2016
In the previous versions of Sql
server, this function was used to construct a message from strings located in sys.messages.
FORMATMESSAGE statement is enhanced
in SQL Server 2016 to enable supply your own string values.
Syntax:
FORMATMESSAGE ( { msg_number | '
msg_string ' } , [ param_value [ ,...n ] ] )
Example:-
DECLARE @ExampleMessage VARCHAR(150)
SET @ExampleMessage = FORMATMESSAGE('code-sample very popular from %s year
and this is included in top %s best site','2013','5');
SELECT @ExampleMessage AS 'OUTPUT';
OUTPUT
code-sample very popular from 2013
year and this is included in top 5 best site
SELECT FORMATMESSAGE('%s and %s is the most popular tutorial sites for the
develper', 'www.code-sample.com', 'www.code-view.com') AS Result;
Result
www.code-sample.com and www.code-view.com is the most popular
tutorial sites for the developer