• SQL Server
• ::
• User Defined Function
• ::
• Inline Table-valued Functions

subject:Inline Table-valued Functions
syntax:CREATE FUNCTION [owner_name.]function_name
	( @parameter [ AS ] data_type [ =default ] )
RETURNS TABLE
[ WITH { ENCRYPTION | SCHEMABINDING } ]
[ AS ]
RETURN
	[ ( ]
		<select_statement>
	[ ) ]
content:เป็นการสร้าง function ที่จะ คืนค่าออกมาเป็น table
example:CREATE FUNCTION udf_productByTypeOf
	( @typeId int )
RETURNS TABLE
AS
RETURN
	(
		SELECT id, name, price
		FROM product
		WHERE type_id = @typeId
	)
DO