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
28666 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

What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?

993

How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?

968

Can we do database operations without using any of the ado.net objects?

978

Explain the different row versions available in table?

1050

Does entity framework use ado.net?

969

What is microsoft ado?

999

How do you update a dataset in ado.net?

1020

What is the use of ADO.NET and XML web services?

1041

Explain the namespaces in which .net has the data functionality class.

1073

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

1019

What is ambient transaction?

941

What is ole data type?

909

What is untyped dataset?

1091

what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?

1011

What are the important features of ado.net 2.0?

1071