Difference between Function and Stored Procedure?
- 9 Answers
- 19023 Views
- C1 India, NA, I also Faced
- E-Mail Answers
Answer Posted / arvind kumar
1-Function can not return the value but store procedure
return value
2-Store procedure is pree-compile statement but function is
not pree-compile satement.
3 function fallowed by select statement but store procedure
fallowed select, insert,update statement.
| Is This Answer Correct ? | 2 Yes | 40 No |
Post New Answer View All Answers
please differentiate between delete and truncate?
Describe how to use the linked server?
Explain a differential backup?
What does normalization do to data?
How to create percentile function?
When we should use and scope of @@identity?
Do you know what is sql injection?
What is the difference between the application object and session object?
Do you know what are the steps to process a single select statement?
What is exclusive locks?
How to create a trigger for insert only?
Explain what are various ways to enhance the ssrs report?
what is raid and what are different types of raid configurations? : Sql server database administration
How can we solve concurrency problems?
What is difference between standardization and normalization?
