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 vote159 views1 answer
Mysql foreach insert
SQL
0 vote167 views1 answer
WHERE not regex in SQL
SQL
3 votes188 views5 answers
Duplicate table sql
SQL
3 votes167 views1 answer
Oracle apex message quit website
SQL
0 vote161 views1 answer
Firebird where
SQL
0 vote147 views1 answer
Mysql case when null
SQL
-1 vote156 views1 answer
Ssql to lowercqse
SQL
45 votes240 views5 answers
Grant all privileges mysql
SQL
0 vote157 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
0 vote165 views1 answer
Select insert new table sql server
SQL