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 vote227 views1 answer
Postgresql append array
SQL
0 vote187 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
0 vote210 views1 answer
Transalations from sql to Linq count and group by
SQL
5 votes184 views1 answer
Oracle find foreign key dependencies
SQL
0 vote213 views3 answers
Find below average salary in sql
SQL
0 vote181 views1 answer
How to reset the database value in SQL server
SQL
0 vote198 views1 answer
Connect to ssms with python
SQL
0 vote192 views1 answer
Insert into Select * - NAYCode.com
SQL
0 vote179 views1 answer
Mysql url
SQL
15 votes379 views2 answers
How to sort names in alphabetical order in sql
SQL