stored procedure we may use return statement.. but in user defined functi

Differnce between Stored procedure and user defined functions?

Question Posted / ramesh

Answer Posted / ramesh

stored procedure we may use return statement.. but in user
defined function we should use return statement

Is This Answer Correct ?

14 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What is the executescalar method?

1014

Which method is used by command class to execute SQL statements that return single value?

980

How to add an aggregate column?

940

What is the default Timeout for SqlCommand.CommandTimeout property?

952

What are the benefits of ADO.NET?

1060

What is the difference between SqlCommand and SqlCommandBuilder?

997

Explain the different row versions available in table?

974

What is ambient transaction?

885

Why is ADO.NET serialization slower than ADO ?

998

How can we add/remove row's in "datatable" object of "dataset"?

968

Difference between sqlcommand and sqlcommandbuilder?

1052

How can we check that some changes have been made to dataset since it was loaded?

915

What is the use of connection object in ado.net?

990

What is openrowset?

917

If a table contains 20000 records. In a page at each time 100 records to be displayed.

838