What are the difference between function and stored procedure in .net programming language?



What are the difference between function and stored procedure in .net programming language?..

Answer / Rishish Mishra

"In .NET, functions and stored procedures serve similar purposes but have some differences: Functions return a value (usually scalar) after processing input parameters. Stored procedures do not necessarily return a value but can still take input parameters and perform operations on data in the database. Functions are typically used for calculations, while stored procedures are more complex, multi-statement blocks that manipulate data in databases."n

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ASP.NET Interview Questions

What are different templates available in Repeater,DataList and Datagrid ?

1 Answers  


what do you mean software devlopment ?

9 Answers   HCL,


What are the various ways to send content from one page to another?

1 Answers  


What does aspnet_regiis -i do ?

1 Answers  


What is the difference between CLICK and MOUSE DOWN Event ?

1 Answers   MCN Solutions,


What is windows active directory authentication?

1 Answers  


What do you understand from custom control?

1 Answers   C DAC, CDAC,


Explain the difference between asp.net mvc and asp.net webforms

1 Answers  


how to update data using store procedure

1 Answers  


What is view state management in asp net?

1 Answers  


Differentiate between Server Transfer and Response Redirect?

2 Answers   DELL, Siebel, TCS,


How to Separate background image and front image from original picture....

1 Answers   Sans Pareil IT Services,


Categories