Difference between Function and Stored Procedure?
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
How to create new tables with "create table" statements in ms sql server?
How to round a numeric value to a specific precision?
Find columns used in stored procedure?
What is difference between oltp and olap?
How to fine-tune reports?
What are the events recorded in a transaction log?
Is it possible for a stored procedure to call itself or recursive stored procedure?
What is forward - only cursors / read only cursor?
How to find which stored procedure is currently running in sql server?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
What is onf in normalization form?
What are the triggers in sql?
How to stop log file growing too big?
How do you delete a trigger?
Where in ms sql server is ’100’ equal to ‘0’?