Interested to Buy Any Domain ? << Click Here >> for more details...
Differnce between Stored procedure and user defined functions?
- 17 Answers
- 28651 Views
- Microsoft, Symphony, I also Faced
- E-Mail Answers
Answer Posted / santosh kumar
Sl. No. User Defined function Stored Procedure
1 Function must return a value. Stored procedure may or not return values.
2 Will allow only Select statement, it will not allow us to use DML statements. Can have select statements as well as DML statements such as insert, update, delete
etc
3 It will allow only input parameters, doesn’t support output parameters. It can have both input and output parameters.
4 It will not allow us to use try-catch blocks. For exception handling we can use try catch blocks.
5 Transactions are not allowed within functions. Can use transactions within Stored procefures.
6 We can use only table variables, it will not allow using temporary tables. Can use both table variables aswell as temporary table in it.
7 Stored procedures can’t be called from function. Stored Procedures can call functions.
8 Functions can be called from select statement. Procedures can’t be called from Select/Where/Having etc statements. Execute/Exec
statement can be used to call/execute stored procedure.
9 UDF can be used in join clause as a result set. Procedures can’t be used in Join clause
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is an ado?
What DataReader class do in ADO.NET ?
What does sqldatareader return?
What are different layers of ADO.Net?
What is Data Provider?
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?
What is the use of SqlCommandBuilder?
Explain the advantages and disadvantages of using datalist?
What do you mean by performing asynchronous operation using command object?
Which ado.net object is very fast in getting data from the database?
How is entity framework different from ado.net?
Define connection string?
Define Execute Reader?
What are the major difference between classic ADO and ADO.NET?
Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?
