http://blogs.msdn.com/b/pradeepsvs/archive/2014/10/09/difference-between-a-stored-procedure-and-function.aspx
Function must return any values and stored procedure can either return value or not.