Which one is best StoredProcedure or SQL Function

Question

0.00/5 (No votes)

See more:

Hello buddy ........

Thanks of all.......

I am use a stored procedure , in this sp i am call a another sp or another function
these will return a value , My Query is which one better in sp or function.
Any one tell me a powerful region.

As like.........

Create proc testProcedure
as

exec anotherProcedure -- It is return a value ---No1

SELECT dbo. anotherFunction (@Parameter) -- Itis return a value---No2

so which one is better use both of them.

Thanks.

sanwar

Posted 18-Jul-12 2:43am

sanwar_mal_jat

Add a Solution

Comments

StianSandberg 18-Jul-12 8:53am

Functions are in general slower.. I never use functions in my sql. And to use a function to do querying is no-go..

sanwar_mal_jat 18-Jul-12 9:28am

plz tell me any logically region can why slower function

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kaushik Saha from Kolkata,India · Accepted Answer · 2012-07-18T03:09:00

Solution 1

function and stored procedure both are stored in compiled format in database.

SQL

SELECT dbo. anotherFunction (@Parameter)

Above statement is better if u need only select statement in function/procedure,because can not execute any other statement.
function can call from any statement.
like

SQL

select anotherFunction(@parameter)

above statement is possible

SQL

select anotherstoredprocedure

above statement is not possible.

Posted 18-Jul-12 3:09am

Kaushik Saha from Kolkata,India

Comments

sanwar_mal_jat 18-Jul-12 9:29am

ya but which one is better (SP or Function)

Kaushik Saha from Kolkata,India 18-Jul-12 9:45am

function is better as per your question.Because you can use in inline.