Some SQL question..

[jack]

Im sorry to post and sql question in the asp.net forum but just wanted
to know

Whats the difference between sql Functions and Procedures?

This is one of the simple question which is common interview question.

 

[Eliyahu Goldin]

You can use functions in expressions like

select formatName (first_name, last_name, middle_name, title) ...

 

[Mark Rae]

Im sorry to post and sql question in the asp.net forum but just wanted
to know

Whats the difference between sql Functions and Procedures?

This is one of the simple question which is common interview question.

Google found this in about 5 seconds:
http://qa.techinterviews.com/q/20060804232021AA6mjm4

 

[jack]

Thanks for replying. but now i got that function can return tables
stored procedues cant.

 

[Mark Rae]

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