SQL Server Table Valued Function. Session 30
Inline table valued functions
• Returns a table.
• Not enclosed between begin and end.
• Can also be used in joins with other tables.
--------------------------------------------------------------------------------
select * from empdetails
select * from emp
create function regiondata(@place varchar(20))
returns table
as
return select * from empdetails where place=@place
----------------------------------------------------------------------------------------
select * from dbo.regiondata('delhi')
---------------------------------------------------------------------------------------------
select e.id,e.name,r.grade from emp e
left join dbo.regiondata('delhi') r
on e.id=r.id
On this page of the site you can watch the video online SQL Server Table Valued Function. Session 30 with a duration of hours minute second in good quality, which was uploaded by the user Sunny@Pandita 14 September 2024, share the link with friends and acquaintances, this video has already been watched 72 times on youtube and it was liked by 4 viewers. Enjoy your viewing!
