Functions in sql server

Question

Hi All,

 

 

Why function must return a value and why s.p. is optional?

 

 

please help me

 

Thanks to All