store procedure takes less time to execute the statement than functions,

Differences between functions and stored procedures?

Question Posted / santhoshkumar.k

Answer Posted / santhoshkumar.k

store procedure takes less time to execute the statement
than functions, also we can create loops inside the store
procedure.

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Do you know what are the ways available in sql server to execute sql statements?

1030

Explain DBCC?

961

What is the purpose of floor function?

1039

How to loop through returning rows?

1034

Can two tables share the same primary key?

917

How do I clean up sql server transaction log?

1066

Explain about SQL server 2005?

975

How to create new table with "create table" statements?

1109

What command do we use to rename a database?

1078

What is the latest version of microsoft sql server?

1047

Differentiate between ms sql server reporting services vs crystal reports?

905

How would you go about developing a ssrs report?

168

What are different replication agents and what's their purpose? : sql server replication

1019

What are the character string functions supported by sql server 2005?

1013

What is nolock?

983