Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 procedure in an funktion?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-06-11 : 21:36:48
michael writes "ALTER function test1(@nr varchar(255)) returns varchar
as
begin
declare @ret varchar(255)

exec TokenFormats 1,@nr,'0000',@ret

return @ret


end


i like to call an procedure in an function...
but i get an error...

Server: Nachr.-Nr. 557, Schweregrad 16, Status 2, Prozedur test1, Zeile 6
Nur Funktionen und erweiterte gespeicherte Prozeduren können innerhalb einer Funktion ausgeführt werden.

what is the way to call an self coded procedure in an function?
thanx"
   

- Advertisement -