Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Function and Stored Procedure?
- 9 Answers
- 21752 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
How do I view views in sql server?
What are scheduled tasks in sql server?
Do you know what are the ways available in sql server to execute sql statements?
Are all views updatable ?
What are different types of replication in sql server?
Explain system scalar functions?
What is query optimizer in sql server?
Does partitioning ssd reduce performance?
Does transparent data encryption provide encryption when transmitting data across the network?
What is a trigger? Why we need it?
Give me any three differences between Truncate and Delete.
Can group by and orderby be used together?
What is openrowset sql server?
Mention the 3 ways to get a count of the number of records in a table.
What are parameterized reports?
