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

How to choose all records from the table?

997

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

940

What is the purpose of sql profiler in sql server? : sql server database administration

1041

What is policy management?

932

How to define output parameters in stored procedures?

958

Which are the olap features?

904

What does asynchronous call backs means?

1069

What is a mixed extent?

948

Why use view instead of a table?

878

What is the purpose of indexing?

994

What are the advantages of using stored procedures?

887

What is the advantage of sql server?

984

What is in place upgrade in sql server?

987

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

884

Can a rule be bound to any column of any data type?

908