Return multiple values from a SQL Server function

How would I return multiple values (say, a number and a string) from a user-defined function in SQL Server?

Solution

Change it to a table-valued function

Please refer to the following link, for example.

Return multiple values from a SQL Server function
How to combine two queries keeping all results from one
SQL JSON continue the INSERT even after the error
Datatype for storing ip address in SQL Server
SQL Server 2005 function to extract a substring match following a set string
Why does CHECKSUM_AGG() return same values for totally different input values?
Get xml-path from a node selected from a document
SQL Server select query where clause
Select most recent record for each member
Chunk insert using Dapper of 5000 rows did not have any performance improvement over inserting row by row
Find non-ASCII characters in varchar columns using SQL Server
Using T-SQL EXCEPT with DELETE / Optimizing a query
SQL Server 2016, Invalid object name 'STRING_SPLIT'
Check the time on datetime columns but ignore the date
Delete duplicate values in a string, preserving sequence
T-SQL How to select the nearest earlier date
Truncate a Datetime at different lengths without DATETRUNC
Using unique index to enforce strict order numbers (that are picked by users)
Enable Ledger on Azure SQL Server, will hang the Azure function execution which add around 65K records
String Expression to be evaluated to number
Why ROUND() function adding too many trailing zeros
How to use an identity column for both automatic values and manual inserts?
How to download a file from a varbinary column using T-SQL
After ingesting a string using SSIS I am unable to convert into date format
Dynamic Pivot Results to a Temp Table
Can you call a webservice from TSQL code?
Change date format in SQL Table
How to format datetime in SQL SERVER
Comma separated results in SQL
Generating random strings with T-SQL