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

5 votes111 views1 answer
Sql asynchronous stored procedure call
SQL
0 vote182 views1 answer
Mysql get nested records
SQL
2 votes133 views1 answer
Sql server current date minus 5 years
SQL
0 vote123 views2 answers
Return the number of records in a single table mysql
SQL
0 vote112 views2 answers
Postgresql change user role grant
SQL
3 votes77 views1 answer
Postgresql where current year
SQL
0 vote121 views1 answer
Like date sql server not working
SQL
13 votes134 views2 answers
Sqlite rename table
SQL
0 vote132 views1 answer
Mysql auto increment default value with prefix month and year
SQL
1 vote121 views1 answer
Print all records of table in mysql
SQL