interview

Home / DeveloperSection / Interviews / What are all types of user defined functions?

Ask Question
Shrikant Mishra

Shrikant Mishra

Follow
I'm a professional writer and Business Development with more than 10 years of experience. I have worked for a lot of businesses and can share sample works with you upon request. Chat me up and let's get started.

Can you answer this question?

Answer

1 Answers

Shrikant Mishra

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
MindStick Training

Liked By