What is the difference between a stored procedure and a function?.

  • Thread starter Thread starter Guest
  • Start date Start date
jemrick said:
When do I use and what is the difference?

A function can be used as a table; an SP can't.

A function returns a defined data type (including table); an SP can but
doesn't have to.
 
Back
Top