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.

Remarks

See Also

Reference

System.Globalization Procedures
System.Globalization Schema

Send comments about this topic to Microsoft.