Table valued functions in sql

-- create function
CREATE [OR ALTER] FUNCTION <FUNCTION NAME> (@<PARAMETER NAME1<DATATYPE>
[SIZE], .......)
RETURNS TABLE
AS
RETURN( <SELECT QUERY/ STATEMENT>)

-- call function
SELECT * FROM <FUNCTION NAME> (VALUE / VALUES);

Similar codes

5 votes205 views3 answers
Day of week postgresql
SQL
2 votes180 views2 answers
Sqlalchemy filter or
SQL
61 votes1.2K views6 answers
Mysql add column
SQL
0 vote313 views4 answers
Stored procedure sql
SQL
7 votes220 views3 answers
Sql server check if temp table exists
SQL
1 vote360 views3 answers
Sql subquery
SQL
0 vote200 views1 answer
Pass array parameter to stored procedure c#
SQL
2 votes187 views1 answer
How to insert string variable into sqlite database
SQL
0 vote184 views1 answer
How to check the port of mysql installation in mac
SQL
0 vote184 views1 answer
Database traccar
SQL