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

Difference between Function and Stored Procedure?

Question Posted / sumesh.tc

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

Please Help Members By Posting Answers For Below Questions

Why the trigger fires multiple times in single login?

1215

How much memory that we are using in Logshipping Concept?

1799

Where can you add custom error messages to sql server?

1130

What do you understand by mirroring and mention the advantages of the mirroring?

1068

Explain syntax for viewing, dropping and disabling triggers?

961

User wants only to display only pdf as export option in report manager. How to achieve this?

262

which backup strategy you are following at ur company

2149

How do I delete a sql server database?

1048

can an order by clause be used in a creation of a view?

1185

What are filegroups in sql server?

1067

Can you force a query to use a specific index?

949

How do I view a stored procedure in sql server query?

936

What is difference between views and stored procedures?

994

How to check status of stored procedure in sql server?

990

What is nonclustered index with included columns ?

969