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

5 votes174 views1 answer
Oracle list packages
SQL
0 vote173 views1 answer
Sql put two columns into one
SQL
1 vote197 views2 answers
Intersect sql
SQL
8 votes185 views1 answer
Declare table variable sql server
SQL
0 vote182 views1 answer
Mysql docker image for macbook m1
SQL
0 vote164 views1 answer
Show table structure mysql console
SQL
0 vote167 views1 answer
Sql compound operators
SQL
0 vote184 views1 answer
Install squirrel sql ubuntu
SQL
1 vote191 views1 answer
Wherein mysql
SQL
0 vote191 views1 answer
Get the Db column names from a SqlDataReader
SQL