Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Function and Stored Procedure?
- 9 Answers
- 22201 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
Why can there be only one clustered index and not more than one?
Is mysql better than sql server?
what is a check constraint?
How to delete exactly duplicate records from a table?
Define views.
List out what other servers you can use with ssrs?
Can you index views?
Why olap is used?
What is b tree index?
What is awe?
What is store procedure? When do you use?
What is function of master database?
Define tool Manage Statistics in SQL Server 2000 query ?
How to achieve Paging of records in SQL SERVER?
Does the unique constraint create an index?
