Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Function and Stored Procedure?
- 9 Answers
- 22128 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 the types of database schema? : sql server analysis services, ssas
Explain datetime2 data type in sal server 2008?
What is the difference between clustered and a non-clustered index?
How many types of functions are there in sql server?
What is a filestream?
Determine when an index is appropriate?
Can an entity have two primary keys?
How to use transact-sql statements to access the database engine?
Where can you find the error log information? : sql server database administration
Using the customer, and order table in northwind database, please write a query to produce xml?
How to include text values in sql statements?
Explain the rules for designing files and file groups in sql server?
Where is my database stored on the hard disk in ms sql server?
What is the default sql server instance name?
How to encrypt data between dialogs?
