SQL Server Articles

Submit Article
Home » Articles » SQL Server » System FunctionsRSS Feeds


Posted By: Sarita Patel     Category: SQL Server     Views: 2352

This article explains about FORMATMESSAGE function in sql server with examples.

FORMATMESSAGE function constructs a message from an existing message in sysmessages.

FORMATMESSAGE edits the message by substituting the supplied parameter values for placeholder variables in the message.

FORMATMESSAGE looks up the message in the current language of the user. If there is no localized version of the message, the U.S. English version is used.

Syntax of FORMATMESSAGE Function :

FORMATMESSAGE ( msg_numberparam_value [ ,...n ] )

msg_number is error id of the message stored in sysmessages system table. It returns null when error id is not exists in sysmessages table.

param_value is one or more parameter values for use in the message. The values must be specified in the order in which the placeholder variables appear in the message. The maximum number of values is 20.

Return type of FORMATMESSAGE function is a nvarchar.

Examples of FORMATMESSAGE Function :

Example 1 : Use of FORMATMESSAGE function in select clause 


Too many table names in the query. The maximum allowable is 15.

Above example returns formatted error message by substituting the value 15 for the parameter placeholder.


Didn't find what you were looking for? Find more on FORMATMESSAGE Function Or get search suggestion and latest updates.

Sarita Patel
Sarita Patel author of FORMATMESSAGE Function is from United States.
View All Articles

Related Articles and Code:

Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

No Comment Found, Be the First to post comment!