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 votes197 views1 answer
Tsql copy table
SQL
2 votes216 views2 answers
Mysql search for column name in all tables
SQL
0 vote202 views1 answer
Select in select sql
SQL
0 vote206 views1 answer
Can sqldatareader be null
SQL
23 votes217 views2 answers
Query to delete a database in mysql
SQL
1 vote227 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
10 votes207 views1 answer
Oracle dependencies table
SQL
0 vote221 views1 answer
Sql order by except one row
SQL
0 vote201 views1 answer
Replace multiple string in query sql
SQL
5 votes221 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL