Interested to Buy Any Domain ? << Click Here >> for more details...
Differnce between Stored procedure and user defined functions?
- 17 Answers
- 28104 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 the difference between sqlcommand and sqldataadapter?
What are the namespaces used in ADO.Net to connect to a database?
Which provider is used to connect ms access, oracle, etc…?
What is difference between executenonquery and executequery?
Where is adodb dll located?
What is difference between connected and disconnected architecture in ado.net?
What is a datareader object?
Some important instruction regarding ADO.NET connection string ?
Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?
What is isolation?
What is the difference between Dataset. clone and Dataset.copy?
What is the difference between Data adaptor and Data set?
I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?
Define connection string?
Which object is used to add relationship between two Datatables?
