Return Table from Function in SQL Server

chetan

SOLVED CLOSED ACTIVE ANSWERED
User: chetan
Posted: on Mar 01, 2019 12:58 AM
Forum: SQL Server
Answer: 1
Views: 1836

I know how to return a table in Stored procedure:

CREATE PROCEDURE Test

AS
    DECLARE @tab table (no int, name varchar(30))

    insert @tab  select eno,ename from emp  

    select * from @tab
RETURN

Same way,how to return a table in Functions and does functions has output parrametres?

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on Mar 01, 2019 01:05 AM
Report

Hi chetan,

I have made use of the following table Customers with the schema as follows.

I have already inserted few records in the table.

You can download the database table SQL by clicking the download link below.

Download SQL file

SQL

CREATE FUNCTION fn_GetCustomers()
RETURNS  @tblCustomers TABLE 
(    
	Id INT NULL,
	Name VARCHAR(100) NULL,
	Country VARCHAR(50) NULL
)
AS
BEGIN

	INSERT INTO @tblCustomers 
	SELECT * FROM Customers
RETURN
END
GO
SELECT * FROM fn_GetCustomers()

Output

Id	Name	Country
1	John Hammond	United States
2	Mudassar Khan	India
3	Suzanne Mathews	France
4	Robert Schidner	Russia

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Return Table from Function in SQL Server

Company

Explore

Follow us

Contact Us