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

2 votes306 views1 answer
Ifnull postgres
SQL
0 vote297 views1 answer
T-SQL Create Trigger
SQL
0 vote305 views1 answer
Grant privileges of databse to user
SQL
4 votes321 views1 answer
How to drop a database in sql server when it is in use
SQL
0 vote272 views1 answer
Truncate table sql server foreign key
SQL
0 vote278 views1 answer
Sum value by month sql
SQL
0 vote290 views1 answer
Window function to forward fill
SQL
1 vote303 views1 answer
Postgresql append array
SQL
0 vote272 views2 answers
Plsql function that return a table
SQL
1 vote277 views2 answers
Sql select only row with the max date
SQL