function always returns a value where as procedure will returns a value sometimes function can becalling in select statement where as procedure can be calling by using exec procedure name or in between begin and end