xp_sprintf (Transact-SQL)
Applies to: SQL Server
Formats and stores a series of characters and values in the string output parameter. Each format argument is replaced with the corresponding argument.
Transact-SQL syntax conventions
Syntax
xp_sprintf { 'string' OUTPUT , 'format' }
[ , 'argument' [ , ...n ] ]
Arguments
'string' OUTPUT
A varchar variable that receives the output.
When OUTPUT
is specified, this option puts the value of the variable in the output parameter.
'format'
A format character string with placeholders for argument values, similar to the values supported by the C-language sprintf
function. Currently, only the %s
format argument is supported.
'argument'
A character string that represents the value of the corresponding format argument.
n
A placeholder that indicates that a maximum of 50 arguments can be specified.
Return code values
0
(success) or 1
(failure).
Result set
xp_sprintf
returns the following message:
The command(s) completed successfully.
Permissions
Requires membership in the public role.
Related content
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें