Multiple Return SQL Server Function

Table value function

For return more than value from SQL-Server? To do so you need to make table value function.

A table value function use to return more than one value in the form of table.

USE [Girfa_portal]

GO

/****** Girfa Student Help ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

create FUNCTION [dbo].[getBookIssueFineDay]

(

       @roll int

)

RETURNS  TABLE

as

return (select Name,City from Student where Roll=@roll)

Calling

select * from getBookIssueFineDay(100)

Next Example