FUnction use when you want to return any value only but SP is best for all

Differences between functions and stored procedures?

Question Posted / purushotam bhardwaj

Answer Posted / purushotam bhardwaj

FUnction use when you want to return any value only
but SP is best for all

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is parameterized reports in ssrs ?

141

Explain left outer join and right outer join?

972

do you know how to configure db2 side of the application? : Sql server database administration

986

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

1042

What is the difference between ‘having’ clause and a ‘where’ clause?

991

What is the command used to recompile the stored procedure at run time?

1016

Do you know what is blocking?

899

What are magic tables in sql server?

1068

What are types of subqueries?

995

How to use copy and concatenate commands in SQL?

1064

How to find the source of a table in sql server?

921

How to filter records of table in SQL SERVER?

1025

How to turn on the mssql api module in php?

1015

What is the meaning of resultset type_scroll_insensitive?

910

Can we write a distributed query and get some data which is located on other server and oracle database?

1176