FormatString Procedure (System.Globalization Schema)
[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]
Returns a formatted string based on the string template and substitution strings.
[System.Globalization].[FormatString] ( @format, @result OUTPUT, @item0, @item1, @item2, @item3, @item4, @item5, @item6, @item7, @item8, @item9 )
Arguments
@format
Type: nvarchar(max). A template for formatting the output string. Indexed format items within braces are replaced by the "item" parameter values. For example, the string "{0}" would be replaced by the value of parameter @item0.
@result
Type: nvarchar(max). The returned formatted string. This is an OUTPUT parameter.
@item0
Type: nvarchar(max). An optional string to replace in the format string.
@item1
Type: nvarchar(max). An optional string to replace in the format string.
@item2
Type: nvarchar(max). An optional string to replace in the format string.
@item3
Type: nvarchar(max). An optional string to replace in the format string.
@item4
Type: nvarchar(max). An optional string to replace in the format string.
@item5
Type: nvarchar(max). An optional string to replace in the format string.
@item6
Type: nvarchar(max). An optional string to replace in the format string.
@item7
Type: nvarchar(max). An optional string to replace in the format string.
@item8
Type: nvarchar(max). An optional string to replace in the format string.
@item9
Type: nvarchar(max). An optional string to replace in the format string.