Interested to Buy Any Domain ? << Click Here >> for more details...
Differnce between Stored procedure and user defined functions?
- 17 Answers
- 29267 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
How to add an aggregate column?
Which is the feature of ado.net?
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?
Define the executescalar method?
Define table relations?
What is datatable in ado.net?
What are the different methods available under the sqlcommand class to access the data?
Define Execute Scalar?
Which control of the BindingNavigator returns the current position within the data source?
What do you mean by ‘batch updates’?
What is the full form of ado?
how we can fire event in databound coulm in datagfrid withot using button?
Explain the various objects in dataset.
What providers does Ado.net uses?
What is the use of sqldatareader class?
