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

3 votes345 views1 answer
Mysql cli connect with password
SQL
4 votes279 views2 answers
Convert utc to est sql
SQL
1 vote282 views1 answer
Is sql fast
SQL
22 votes273 views4 answers
Show list of users in mysql
SQL
0 vote282 views1 answer
Oracle SQL join three tables and group by column
SQL
0 vote278 views1 answer
Dump db only triggers mysql
SQL
0 vote312 views1 answer
Add new column in sql with foreign key
SQL
6 votes259 views1 answer
Sqlite foreign key
SQL
1 vote263 views1 answer
Mysql show current queries
SQL
0 vote277 views1 answer
Xampp increame mysql speed
SQL