Wednesday, 21 June 2017

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)