Collections:
Syntaxes of Creating Table-Valued Functions in SQL Server
How Many Ways to Create Table-Valued Functions in SQL Server Transact-SQL?
✍: FYIcenter.com
SQL Server supports two syntaxes of creating table-valued functions:
1. Inline Table-valued Functions - A table-valued function created with a single SELECT statement:
CREATE FUNCTION function_name( @parameter_1 data_type, @parameter_2 data_type, ... @parameter_n data_type ) RETURNS TABLE AS RETURN (select_statement);
2. Multi-statement Table-valued Functions - A table-valued function created with a local temporary table and a statement block:
CREATE FUNCTION function_name( @parameter_1 data_type, @parameter_2 data_type, ... @parameter_n data_type ) RETURNS @table_variable_name TABLE ( column_definition_list) AS BEGIN statement_1; statement_2; ... statement_n; RETURN END
⇒ "RETURNS TABLE" - Creating Inline Table-Value Functions in SQL Server
⇐ Categories of Functions Based on Return Modes in SQL Server
2016-12-18, 1448🔥, 0💬
Popular Posts:
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...