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, 1537🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...