Table values functions in SQL

CREATE FUNCTION udfProductInYear (
    @model_year INT
)
RETURNS TABLE
AS
RETURN
    SELECT 
        product_name,
        model_year,
        list_price
    FROM
        production.products
    WHERE
        model_year = @model_year;
Code language: SQL (Structured Query Language) (sql)

Source: sqlservertutorial.net

Similar codes

3 votes174 views3 answers
Start postgresql ubuntu
SQL
0 vote150 views1 answer
Mysql to get column name in database
SQL
3 votes156 views1 answer
Mysql insert on dupèlicate
SQL
3 votes143 views1 answer
Index using in query plsql
SQL
33 votes142 views2 answers
Postgres how to add field created at
SQL
3 votes154 views1 answer
Fk in insert mysql
SQL
0 vote159 views1 answer
Mysql type for large numbers with many decimal
SQL
0 vote149 views1 answer
Postgres enumerated type
SQL
0 vote176 views1 answer
Mysql date without time
SQL
0 vote153 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL