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

1 vote273 views3 answers
Reset sql primary key
SQL
0 vote292 views1 answer
000webhost database values insert
SQL
0 vote292 views1 answer
Mysql zerofill
SQL
1 vote291 views1 answer
Sql server today minus n
SQL
2 votes280 views1 answer
Update with join sql server
SQL
0 vote292 views1 answer
Allow null in psql
SQL
1 vote263 views1 answer
Get url of cpanel database hostname
SQL
0 vote244 views1 answer
Split a string with expression and get the last value of split sql
SQL
0 vote305 views2 answers
How to install psql in ubuntu
SQL
0 vote287 views1 answer
Repeatable read trong sql server
SQL