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 vote197 views1 answer
To_date sql
SQL
1 vote194 views3 answers
Update from select sqlite
SQL
1 vote196 views1 answer
Mysql count all table rows
SQL
0 vote204 views1 answer
Hou to run job from cmd .exe sql server jop
SQL
5 votes187 views1 answer
How to check nls format in oracle
SQL
0 vote244 views1 answer
T-sql delete view if exists
SQL
-1 vote194 views1 answer
Count occurrences sql
SQL
0 vote177 views1 answer
Join creating duplicate columns sqllite
SQL
0 vote193 views1 answer
Drop-toys-table
SQL
0 vote225 views1 answer
Set mysql socket file docker windows
SQL