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

0 vote226 views1 answer
Sql insert from excel
SQL
0 vote238 views1 answer
Select multiple row from primary key sql
SQL
1 vote234 views1 answer
Generate random data postgresql
SQL
3 votes229 views1 answer
Sql server version query
SQL
1 vote215 views2 answers
T-sql random number for each row
SQL
0 vote250 views1 answer
Shows all databases created by user in ms sql
SQL
0 vote247 views1 answer
Mysqli_connect using prepare statement
SQL
0 vote237 views1 answer
How to run mysql on terminal mac
SQL
0 vote238 views1 answer
Sql show table name in result
SQL
0 vote225 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL