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 votes124 views1 answer
Pandas to sql index
SQL
0 vote137 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
0 vote135 views1 answer
Replace \n sql
SQL
0 vote125 views1 answer
Group_concat only returns one row
SQL
22 votes165 views4 answers
Mysql format date
SQL
0 vote126 views1 answer
Big table in mysql
SQL
0 vote129 views1 answer
Sqlite referential integrity
SQL
3 votes123 views2 answers
Oracle apex charging debug
SQL
0 vote129 views1 answer
Sql get guid
SQL
0 vote131 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL