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

16 votes137 views2 answers
Oracle ddl
SQL
-1 vote122 views2 answers
Sql server date format yyyy-MM-ddThh:mm:ss
SQL
0 vote151 views1 answer
Sql insert from excel
SQL
0 vote131 views1 answer
Search column name sql
SQL
0 vote139 views1 answer
Sqlite insert or update
SQL
-1 vote137 views1 answer
Concat two columns in sql server
SQL
0 vote129 views1 answer
Sqlcmd no headers
SQL
0 vote125 views1 answer
Mysql isshow
SQL
6 votes130 views4 answers
How to remove unique key in mysql
SQL
0 vote123 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL