i am writing a function in sql server2005 it should return some set of value
create function Fun_Facility(@id int)
declare @result table
set @result Select F_Name as [Facility] from Facility_Mst, Prop_Facilities where FID=F_Id and PropId=34
its giving following error
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'set'.