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
2016-12-18, 693👍, 0💬
Popular Posts:
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...