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

9 votes178 views3 answers
Pyodbc connect to sql server
SQL
16 votes128 views3 answers
Delete row psql
SQL
0 vote122 views1 answer
Sql clear table
SQL
0 vote133 views1 answer
Mysql concatenate select results
SQL
0 vote131 views1 answer
Sql developer connect to sql server
SQL
2 votes145 views2 answers
Convert_tz mysql
SQL
0 vote158 views1 answer
How to pass list as parameter in SQL query
SQL
24 votes130 views4 answers
Postgres delete database
SQL
0 vote128 views1 answer
Ignore case in string sql
SQL
2 votes136 views2 answers
Sql query to copy data from one column to another
SQL