how to create table valued function in sql server .

Anonymous User 2020 16 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 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

forum

how to create table valued function in sql server .

Can you answer this question?

1 Answers