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 vote184 views1 answer
Sql delete dastabase
SQL
1 vote288 views1 answer
Concat first name and last name in mysql
SQL
0 vote169 views1 answer
Mysql concat and use as where column
SQL
0 vote192 views1 answer
Drop index in sql
SQL
10 votes180 views2 answers
SQL rounding numbers
SQL
16 votes167 views1 answer
Sqlserver add column to table
SQL
4 votes167 views1 answer
Mysql copy table with new name
SQL
3 votes187 views1 answer
Select database in sql
SQL
0 vote168 views1 answer
Oracle right characters
SQL
1 vote196 views1 answer
Hangfire clear all jobs
SQL