Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Function and Stored Procedure?
- 9 Answers
- 22492 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 an active database?
Explain datetimeoffset data type in sal server 2008?
What according to you is the difference between mysql and sql server performance?
Explain primary key?
What are different types of subquery?
How many types of stored procedures are there in sql server?
Explain an incremental backup?
What's new in sql management studio for sql server? : sql server management studio
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
Explain alternate key, candidate key and composite key in sql server?
What are different types of replication in sql server?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Benefits of Stored Procedures?
Why do you need a sql server?
What is the rdl file?
