forum

Home / DeveloperSection / Forums / how to create table valued function in sql server .

Ask Question
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

1 Answers

Anonymous User

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 table valued function, which returns
the total of price filtered by a given category . Write the following code in
your query pad – 


 Create function fnGetProductMasters

(  

 @categoryId int


)

returns table

return ( select * from ProductMasters where CategoryId=@categoryId) 


--The above function returns an table.
To test this function, we will write some code as shown below – 

select * from dbo.fnGetProductMasters(2)  
Result
answer 415871610110707
 
MindStick Training

Liked By