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

0 vote369 views1 answer
Sqlite trim
SQL
0 vote349 views3 answers
Sql query checker
SQL
6 votes374 views2 answers
Mysql convert timestamp to date
SQL
0 vote323 views1 answer
Truncate table sql server foreign key
SQL
0 vote331 views1 answer
Inner joint
SQL
1 vote321 views1 answer
Sql injection
SQL
0 vote363 views1 answer
ORA-13717
SQL
1 vote331 views1 answer
Increase existing date in sql oracle
SQL
1 vote374 views3 answers
Mysql on delete set null
SQL
0 vote324 views1 answer
Sql orcale i forgot what my name & password was
SQL