Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Function and Stored Procedure?
- 9 Answers
- 21726 Views
- C1 India, NA, I also Faced
- E-Mail Answers
Answer Posted / arunvs
stored procedure when executed generates execution plan
once and next time when it is executed again it will use
the generated execution plan,it does not generate it again.
sp used to solve a business logic
Function compiles from the beginning and prepares the trace
or execution each time it is called.function can be used to
calculations
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
What are the parts of a function?
Explain how you can deploy an SSRS report?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
What is unique key constraint?
Explain the concept of view and Types of views in SQL server?
What is a virtual table in sql?
What is scan table/view and seek table/view when its occurs? : sql server database administration
What stored procedure would you use to view lock information?
What is dynamic cursor in SQL SERVER?
Where in ms sql server is ’100’ equal to ‘0’?
What are the dis_advantages of stored procedures, triggers, indexes?
What is difference between temp table and cte?
Explain the benefits of user-defined functions?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is sql server query analyzer?
