sql server2000, i try to use function 1

[duchovnick]

Hi,
I try to work with functions but i end by working with errors.
The following is the code to make a function

CREATE FUNCTION aaa (@myDigit INTEGER)
RETURNS INTEGER
AS
BEGIN
  RETURN @myDigit
END

and the following is the code calling that function:

CREATE PROCEDURE bbb @hisDigit INTEGER
AS
BEGIN TRANSACTION
PRINT aaa(@hisDigit)
COMMIT

i couldnt run the above code because during compilation i recieved the following
error message:

Server: Msg 195, Level 15, State 10, Procedure bbb, Line 4
'aaa' is not a recognized function name.

Can anyone tell me what my error is?
Thanks a lot !

 

[AlexCuse]

Do you really think a transaction is necessary for a 'print' command, or is this just in order to provide a simple example?

Anyway, you need to reference UDF like this in your sp:

dbo.aaa(@hisDigit)

Hope it helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[duchovnick]

Hi Alex,
Yes, I made it as simple as i could.
Thanks a lot .