functions return only one value.........sp can used to return more than one value.... function need to be complied each time u use....but sp ones complied u can use it...till if cant change any thing:)