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 I need a report server to run reports in my application?

164

What is unpivot?

1005

Mention the differences between sql server and mysql.

1006

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

1045

What is resource governor in sql server?

985

Explain the properties of a relational table?

1014

How to include text values in sql statements?

1028

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

983

what is a sub-report?

140

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

1003

What are the different types of sql server replication? : sql server replication

1252

Define union, union all, minus, intersect?

973

How do you use a subquery to find records that exist in one table and do not exist in another?

1041

What does sql server mean?

1050

Do you know what is rank function?

1071