20 main differences between Stored procedures and Functions in Sql Server

Differnce between Stored procedure and user defined functions?

Question Posted / lalit raghuvanshi

17 Answers
28762 Views
Microsoft, Symphony, I also Faced
E-Mail Answers

Answer Posted / lalit raghuvanshi

20 main differences between Stored procedures and Functions
in Sql Server
http://www.webcodeexpert.com/2013/04/difference-between-stored-procedures.html

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to copy the contents from one table to another table and how to delete the source table in ado.net?

1039

What does ado stand for in ado.net?

1106

How can you add or remove rows from the datatable object of dataset?

1025

What is difference between datatable and dataset?

1063

What is a string variable?

917

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

891

What do you know about ADO.NET's objects and methods?

979

How do you update a dataset in ado.net and how do you update database through dataset?

928

What is the significance of CommandBehavior.CloseConnection ?

1171

What is the difference between dataset and datatable?

1012

how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?

1016

What is ado and dao?

960

How do you find the count of records in a dataset?

978

What is ado.net tutorial?

948

What are the steps you will take to improve performance? Will you use dataset or datareader?

995