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 vote210 views1 answer
Index a database column sql
SQL
5 votes251 views2 answers
Functions
SQL
4 votes217 views1 answer
Postgresql create table with index
SQL
0 vote210 views1 answer
Sql server inner join convert collation
SQL
0 vote191 views1 answer
Separator mysql
SQL
1 vote222 views1 answer
Oracle sql average
SQL
4 votes224 views1 answer
Create db table
SQL
0 vote219 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote196 views1 answer
Metada in sql
SQL
0 vote227 views1 answer
How to get data from 2 database
SQL