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

2 votes221 views4 answers
Sql query interview questions
SQL
0 vote240 views1 answer
Mysql get hour from datetime
SQL
0 vote221 views1 answer
Primary key multiple colums
SQL
0 vote220 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL
0 vote225 views1 answer
Insert output identity
SQL
4 votes284 views1 answer
Oracle table statistics
SQL
4 votes177 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
0 vote228 views1 answer
Sql drop procedure if exists
SQL
0 vote226 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
0 vote227 views1 answer
Sql dmv to capture updates
SQL