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.
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
Liked By
Write Answer
What are all types of user defined functions?
Join MindStick Community
You have need login or register for voting of answers or question.
Shrikant Mishra
06-May-2019Three types of user defined functions are. :