Is FORMATMESSAGE returns several string for one parameter value?

Question

FORMATMESSAGE function returns NULL when one parameter value using for several msg string.

DECLARE @myvar VARCHAR(10) = 100

SELECT FORMATMESSAGE ('First value %s, Second value %s' , @myvar) AS String

Expected result: First value 100, Second value 100

Actual result: First value 100, Second value null

Answer 1

You need to specify each parameter:

DECLARE @myvar VARCHAR(10) = 100
SELECT FORMATMESSAGE ('First value %s, Second value %s' , @myvar, @myvar) AS String