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 votes125 views1 answer
Sql OR
SQL
0 vote105 views2 answers
Update all columns in one update
SQL
2 votes97 views2 answers
Function in sql
SQL
16 votes107 views4 answers
Mysql import from sql file
SQL
0 vote114 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
2 votes107 views1 answer
Drop table purge
SQL
0 vote111 views4 answers
User defined function sql
SQL
0 vote117 views2 answers
Close external port 3306 with iptables
SQL
2 votes122 views1 answer
Capitalize 1st letter in sql server
SQL
0 vote114 views1 answer
Redudancy in SQL
SQL