how to call a sqlfunction in storedprocedure using Sqlserver 2008?

Question

0.00/5 (No votes)

See more:

SQL-Server

SQL-Server-2008

Hi Friends,
how to call a sqlfunction in storedprocedure using Sqlserver 2008?

Thanks&Regards
Hari

Posted 11-Sep-12 20:37pm

Hari Krishna Prasad Inakoti

Updated 11-Sep-12 21:23pm

v2

Add a Solution

2 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)

Arul R Ece · Answer 1 · 2012-09-11T22:53:00

Solution 3

HI ..

Please find details in below.

SQL

--exec fun_proc 1,2
CREATE PROC fun_proc
 @p_val1 int,
 @p_val2 int
AS
BEGIN
Declare @sum int
select @sum =  dbo.sums(@p_val1,@p_val2)--call function to get the value
print @sum
END
--Function 
create function sums
(
@val int,
@val2 int
)
returns int
as
begin
return(@val + @val2)
end
select dbo.sums(1,2)

Posted 11-Sep-12 22:53pm

Arul R Ece

Comments

Hari Krishna Prasad Inakoti 12-Sep-12 5:58am

Thanq Arul

Arul R Ece 12-Sep-12 6:21am

If it is help for you means accept this as answer

Hari Krishna Prasad Inakoti 12-Sep-12 6:41am

ok.i'll try ur code after that i'll mark ur answer if it is working.

Arul R Ece · Answer 2 · 2012-09-11T21:24:00

Solution 1

Hi,

Please try like below ,

SQL

CREATE PROC fun_proc AS
BEGIN
declare @p_val1 int
Declare @@p_val2 int
select @p_val1 = object_id,@p_val2 = colid from sys.columns where object_name(object_id)= 'myTable'
declare @selVal as integer
set @selVal = select dbogetCalcvalue(@p_val1,@p_val2)--call function to get the value
END

Posted 11-Sep-12 21:24pm

Arul R Ece

Comments

Hari Krishna Prasad Inakoti 12-Sep-12 3:29am

if we using like ur format values are update in table?

Arul R Ece 12-Sep-12 4:32am

Hey ,
This is just example foramt pa....

Hari Krishna Prasad Inakoti 12-Sep-12 5:57am

itz ok...