Difference between Function and Stored Procedure?
- 9 Answers
- 19043 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 are relationships and mention different types of relationships in the dbms
What is the difference between SQL notification and SQL invalidation?
what is package and it uses and how can u call a package
Explain magic tables in sql server?
What are the extra roles available in msdb? : sql server security
What is @@error in sql?
How to start and end transact-sql statements?
Explain what are various ways to enhance the ssrs report?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What is merge replication?
What are the character string functions supported by sql server 2005?
What is the ‘fillfactor’?
What are group functions in query statements in ms sql server?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What are the pre-defined functions in the sql server?
