how to create scalar valued function in sql server.

Anonymous User 2026 15 Oct 2015

Can anyone please help me how to solve this problem.

Anonymous User

Other

I am a content writter !

1 Answers

Anonymous User 16 Oct 2015

--let’s start querying create a table.
 CREATE TABLE ProductMasters(
       ProductId int IDENTITY(1,1) primary key,
       ProductName nvarchar(max) ,
       Price decimal(18, 2)  ,
       CategoryId int  
 )
 --We will now create a scalar function, which returns the
total of price filtered by a given 
category . Write the following code in your query pad – 

 Create function fnGetTotatPrice
(  
 @categoryId int
)
returns decimal(10,2)
As
Begin return ( select sum(price) from ProductMasters where CategoryId=@categoryId) 
end

--The above function returns an integer
value. To test this function, we will write some code as shown below – 
select dbo.fnGetTotatPrice(2) as price

forum

how to create scalar valued function in sql server.

Can you answer this question?

1 Answers