Programming Examples

Are you a Programmer or Application Developer or a DBA? Take a cup of coffee, sit back and spend few minutes here :)

Tag Archive for ‘SQL Cursor’

SQL Table-Valued Function Example

Multi-line table valued function example

In the past article we saw creating a simple scalar-valued function. Now, here in this article, we will look at building the Table-Valued function. Unlike the scalar-valued function a table-valued function returns a table to the caller. There are two kinds of table-valued functions we can write. Those are:

In-Line Table-Valued functions
Multi-line table valued functions

In this Example, we learn how to create both the functions. OK, let us start.

Continue Reading →