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

0 vote299 views1 answer
Oracle list index on table
SQL
0 vote330 views1 answer
Mysql drop trigger
SQL
2 votes341 views1 answer
Metasploit start postgresql
SQL
1 vote342 views1 answer
Psql view enum values
SQL
0 vote314 views1 answer
Sql revert migration
SQL
0 vote396 views1 answer
Oracle simple quote
SQL
19 votes324 views6 answers
Create table sqlite
SQL
3 votes312 views1 answer
Sql server check version
SQL
0 vote306 views1 answer
Mysql docker image for macbook m1
SQL
0 vote258 views1 answer
Microsoft sql server management studio clear cache
SQL