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

1 vote199 views1 answer
Raise application error in oracle
SQL
0 vote204 views1 answer
Ubuntu stop mysql from starting on boot
SQL
0 vote187 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
0 vote211 views1 answer
Automated psql csv export script on windows
SQL
0 vote198 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
0 vote146 views1 answer
Finish transaction sql
SQL
2 votes177 views1 answer
Plsql block
SQL
0 vote217 views1 answer
Sql column contains special character
SQL
1 vote193 views1 answer
Mysql view current queries
SQL
0 vote188 views1 answer
Inner joint
SQL