Differnce between Stored procedure and user defined functions?

Answer Posted / ashok

Main difference between sp and function is we cannot use
store procedure in select statement where as we can use
function in select statement.

Is This Answer Correct ?    32 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Give an example of a .net application which connects to microsoft access database using ado.net classes.

589


What is ole2 format?

504


What is the namespaces being used to access oracle database?

519


Explain the advantage of ADO.Net?

554


What is the difference between sqldatareader and sqldataadapter?

494






How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?

569


What is Serialization in .NET? what are the types of Serialization?

555


What is disconnected architecture in ado.net?

506


Define connection string?

586


Which database is the ado.net sql connection object designed for?

595


how can implement dropdownlist in particular of dataset when try to update?

2308


Which object of ado contains datarow datacolumn collection?

516


What are the benefits of using of ADO.NET in .NET 4.0?

539


What is data access pattern?

493


What is the difference between data grid and data repeater?

506