SQL Server

Creating a table-valued function in SQL server



 Like (1)  Dislike (0)

The following statement example creates a table-valued function that returns a list of products including product name, model year and the list price for a specific model year.

CREATE FUNCTION exFUNCTION (
@y INT
)
RETURNS TABLE
AS
RETURN
SELECT
x,
t,
y
FROM
products
WHERE
y = @y

0 Comment's

Comment Form

Submit Comment
If opportunity doesn’t knock, build a door.⛩

Popular Post

WPF

How to Use Logger in WPF Application

C-Sharp

Update Specific Users Out of Oce Settings C# with Example

C-Sharp

Retrieve Specified User''s Out of O ce Settings C# with Example

C-Sharp

Large Object Heap compaction C# with Example

C-Sharp

Weak References C# with Example

C-Sharp

Source code in the view C# with Example