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 vote162 views2 answers
Find nth highest salary of an employee
SQL
1 vote157 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
0 vote155 views1 answer
Postgresql using reserved word as column name
SQL
0 vote143 views2 answers
Homebrew nysql launch
SQL
0 vote159 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
4 votes152 views3 answers
How to describe a table in sqlite3
SQL
0 vote155 views1 answer
Oserror mysql_config not found virtualenv
SQL
0 vote150 views1 answer
Call object contructor and call methods of object
SQL
0 vote145 views1 answer
Not between mysql
SQL
0 vote120 views1 answer
Postgres create database if not exists
SQL