SQL Server - Can Function Return Multiple Values in SQL Server 2008

Introduction:

Here I will explain how SQL Server function will return multiple values in SQL Server 2008 or return multiple values from SQL user defined function in SQL Server 2008.    

Description:

In previous posts I explained SQL Server difference between view and stored procedure, SQL Server split function example to split comma separated string, SQL Server update statement with inner joins, interview questions in asp.net, sql server, c# and many articles relating to SQL Server. Now I will explain how SQL Server function will return multiple values in SQL Server 2008.

Whether functions will return multiple values or not?

For this question answer will be Yes functions will return either single or multiple values.  

Generally SQL Server functions will return only one parameter value if we want to return multiple values from function then we need to send multiple values in table format by using table valued functions.

Sample function which return table as parameter

CREATE FUNCTION testmultiplevalues ( @UserId INT ) returns table as return ( Select * from UserInformation WHERE UserId=@userId )

We can call this function in our query like as shown below

SELECT * FROM dbo.testmultiplevalues(14)

If we run above query we will get output like as shown below

Demo

If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

Subscribe by RSS Subscribe by Email