Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Function and Stored Procedure?
- 9 Answers
- 22176 Views
- C1 India, NA, I also Faced
- E-Mail Answers
Answer Posted / deepak
1)Functions cannot affect the state of the database which
means we cannot perform insert,delete,update and create
operations on the database.
Stored Procedures can affect the state of the database by
using insert,delete,update and create operations.
2)Functions are basically used to compute values
stored procedures are basically used to process the task.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is spatial and temporal data?
What is clr ddl trigger?
How to apply cascading referential integrity in place of triggers?
Explain difference between control flow and data flow?
Explain user defined views?
What is the difference between row_number and dense_rank?
How to create database with physical files specified in ms sql server?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
Can you leave a union at any time?
What are the drawbacks of reporting in ssrs?
How to stop a loop early with break statements in ms sql server?
What is nolock?
What is a result set object returned by odbc_exec()?
Can you pass expressions to stored procedure parameters?
What is the library index called?
