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 votes111 views3 answers
Mysql declare variable
SQL
0 vote99 views1 answer
Oracle list subpartitions
SQL
3 votes109 views2 answers
Sqlite print all column names
SQL
3 votes103 views1 answer
RENAME table pl sql
SQL
11 votes107 views2 answers
Mysql set safe mode off
SQL
3 votes119 views1 answer
Where id is in list sql
SQL
0 vote100 views2 answers
Sql join on wildcard
SQL
2 votes100 views1 answer
Sql like variable
SQL
2 votes111 views1 answer
Guid to string sql
SQL
0 vote177 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL