some info about t-sql functions

functions.sql

 --table valued function
 create function tableValuedFunction()
 returns table
 as
	return(select * from TBL_FOO)
	
--using table-valued func
select * from tableValuedFunction()


--scalar valued func
create function scalarFunc(@ID int)
returns int
as
begin
	return(@ID)
end

--using scalar func
select dbo.scalarFunc(2)

--using in select statement, in a view maybe?
select *, dbo.scalarFunc(TBL_FOO.id) from TBL_FOO