Difference between Function and Stored Procedure?
- 9 Answers
- 18982 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 optimization and its types?
How many levels of sp nesting is possible?
What is the difference function and stored procedure?
How to get the definition of a user defined function back?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
how many clustered indexes can be created on a table? : Sql server database administration
How to assign new column names in a view?
How to enforce security in sql server? : sql server security
How to list all triggers in the database with sys.triggers in ms sql server?
Explain some stored procedure creating best practices or guidelines?
Can sub report data source be different from that of the parent report?
What are the restrictions applicable while creating views? : SQL Server Architecture
How to define and use table alias names in ms sql server?
What do you mean by the term 'normalization'?
How does using a separate hard drive for several database objects improves performance right away?
