calling function in stored procedure

Question

0.00/5 (No votes)

See more:

C#

Can anyone help? How can I call a function in a stored procedure in c#?

Posted 28-Oct-10 18:47pm

Rajesh Yerramsetti

Updated 28-Oct-10 18:52pm

JF2015

v2

Add a Solution

4 solutions

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)

arindamrudra · Answer 1 · 2010-10-28T19:41:00

Say you have a function name dbo.ufn_SplitText() it takes the value NVARCHAR(MAX) and NVARCHAR(1), say It Takes the value like
"abc,cde,def" and "," and it returns

abc
cde
def

So you need to call this function in stored procedure like

SELECT * FROM dbo.ufn_SplitText('abc,cde,def',',')

If you need to take the function value from other table then use like ths:

Suppose a table dbo.tbl_test contains ID and Values column and your required column number is @colnumber INT

DECLARE @Variable  NVARCHAR(MAX)
SELECT @Variable = [Values] FROM tbl_test WHERE ID = @colnumber
SELECT * FROM dbo.ufn_SplitText(@Variable,',')

If your separator is not ',' then use your separator like '/' ..
Hope this will help you. Good luck

tadeze · Answer 2 · 2010-10-28T19:19:00

Are you talking about the user defined function udf in database or a function in the program.
When you are calling udf from the stored procedure you can simply call with the stored procedure as it is in the code.
In sql server calling udf from stored procedure may look like this
--assume the stored procedure pass two values to the function to get
sum of the two numbers.

create procedure addTwoNumber
@a int,
@b int
as
begin
declare @c int
--assume the function returns int
set @c = add(@b,@c)
print @c
end

RaviRanjanKr · Answer 3 · 2010-10-28T19:18:00

If you Created StoredProcedure and Want to execute it in SQLServer then you need to use
exec or execute Command followed by Storedprocedure

and to use in C# you need to use CommandType to define it have to use as a StoredProcedure as given below

SqlCommand cmd = new SqlCommand("StoredProcedureCommand",Connection);
           
 cmd.CommandType = CommandType.StoredProcedure;

for More information Navigate the below link to get lots of Solution about stored procedure with C#
Click Here[^]

*dan!sh* · Answer 4 · 2010-10-28T19:51:00

Solution 4

I believe you want to call C# method from inside stored procedure. It depends on the database you are using and the version of it.

If it is SQL 2005/2008, you can .Net load assemblies and call the methods inside those assemblies. Here[^] is an article that will help you doing that.

Posted 28-Oct-10 19:51pm

dan!sh

calling function in stored procedure

4 solutions

Solution 3

Solution 2

Solution 1

Solution 4

Add your solution here

Preview 0