Return multiple values from a SQL Server function

tsql user-defined-functions
Jeremy Stein picture Jeremy Stein · Nov 10, 2008 · Viewed 222.7k times · Source

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

Answer

devio picture devio · Nov 10, 2008

Change it to a table-valued function

Please refer to the following link, for example.

Related questions

Multi-statement Table Valued Function vs Inline Table Valued Function

A few examples to show, just incase: Inline Table Valued CREATE FUNCTION MyNS.GetUnshippedOrders() RETURNS TABLE AS RETURN SELECT a.SaleId, a.CustomerID, b.Qty FROM Sales.Sales a INNER JOIN Sales.SaleDetail b ON a.SaleId = b.SaleId INNER …

Read More
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.Splitfn", or the name is ambiguous

Hai guys, I ve used the following split function, CREATE FUNCTION dbo.Splitfn(@String varchar(8000), @Delimiter char(1)) returns @temptable TABLE (items varchar(8000)) as begin declare @idx int declare @slice varchar(8000) select @idx = 1 if len(@String)<1 or @String is null …

Read More
TSQL How do you output PRINT in a user defined function?

Basically I want to use PRINT statement inside a user defined function to aide my debugging. However I'm getting the following error; Invalid use of side-effecting or time-dependent operator in 'PRINT' within a function. Can this not be done? Anyway …

Read More