how to create Multi-Statement Table Valued function in sql server .

Question

Anonymous User · Answer

--let’s start querying create a table.
and CREATE TABLE UserMasters(
and and and and and and  UserId int IDENTITY(1,1) primary key,
and and and and and and  LoginName nvarchar(max) ,
and and and and and and  password nvarchar(max) ,
and and and and and and  UserName nvarchar(max) and and  )
and CREATE TABLE ProductMasters(
and and and and and and  ProductId int IDENTITY(1,1) primary key,
and and and and and and  ProductName nvarchar(max) ,
and and and and and and  Price decimal(18, 2)and  ,
and and and and and and  CategoryId intand  , 
and and and and and and  Userid int
and )
and --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 – 
and create function fnGetUsernamewithProductMasters
(and  
and @categoryId int
)
returns @customerwithproduct
table(
UserName varchar(100),
ProductName varchar(100),
Price decimal(10,2)
)
as
begin
insert @customerwithproduct
selectand and  b.UserName, a.ProductName,a.Priceand and  from ProductMasters as a inner join UserMasters as b on a.Userid=b.Userid where CategoryId=@categoryId 
return
endand 
--The above function returns an table.
To test this function, we will write some code as shown below – 
select * from dbo.fnGetUsernamewithProductMasters(1)and  
Result

forum

how to create Multi-Statement Table Valued function in sql server .

Anonymous User

Can you answer this question?

1 Answers

Liked By