Difference between Function and Stored Procedure?

Answer Posted / sumesh.tc

stored procedure is precompiled one but Function not( want
to compile each time)

Is This Answer Correct ?    20 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the report model project?

103


What is the log shipping?

590


How to transfer a table from one schema to another?

562


What happens if date-only values are provided as date and time literals?

549


What are the transaction properties?

564






Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

109


How to list all objects in a given schema?

567


Write a code to select distinct records without using the DISTINCT keyword.

654


What do you mean by an execution plan?

570


What is Federation and Federation Member?

80


What is set nocount on and what is set nocount off?

517


How to get a list of columns using the "sp_help" stored procedure in ms sql server?

586


Can we use where and having clause together?

514


Benefits of Stored Procedures?

574


What is public role in sql server?

540