Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

What are all types of user defined functions?

Shrikant Mishra 1519 06 May 2019

1 Answers

Shrikant Mishra 06 May 2019

Three types of user defined functions are. :

Scalar Functions.
Inline Table valued functions.
Multi statement valued functions.

Example :-
CREATE FUNCTION dbo.udf_GetProductSales 
( 
      @Product VARCHAR(10), 
      @BeginDate DATETIME, 
      @EndDate DATETIME 
) 
RETURNS MONEY 
AS 
BEGIN 
      DECLARE @Sales MONEY 
      SELECT @Sales = SUM(SalePrice) 
      FROM SalesHistory 
      WHERE 
            Product = @Product AND 
            SaleDate BETWEEN @BeginDate AND @EndDate 
      RETURN(@Sales) 
END

advertising

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.