"jack" <ga**********@gmail.comwrote in message
news:11**********************@f1g2000cwa.googlegro ups.com...
Thanks for replying. but now i got that function can return tables
stored procedues cant.
That's true though, for the vast majority of the time, makes no
difference...
Chances are that if your UDF returns a table it does so because you are
interested in the contents of the table anyway, and an SP obviously can
return the contents of a table as a recordset simply by running SELECT *
FROM MyTable