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 vote192 views1 answer
INSERT INTO table using OpenQuery
SQL
49 votes310 views6 answers
Mysql add column to table
SQL
0 vote197 views1 answer
Hw to delete a procedure in pl sql
SQL
0 vote278 views1 answer
Selecting specific day in colum sql
SQL
0 vote197 views1 answer
Vowels in sql
SQL
0 vote195 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
0 vote210 views1 answer
Sql select most frequent value in column
SQL
1 vote212 views1 answer
Select 2 rows in sql
SQL
2 votes238 views1 answer
Sql count having
SQL
6 votes233 views2 answers
Mysql 1 day ago
SQL