Stored procedure - user defined function. -- sql server (alternate)

John Bell
2/21/2004 8:30:13 PM

Hi

You may be able to call the function from a linked server, but in general I
don't think it will perform well. You would be better re-writting it as a
SQL Server function, stored procedure or an extended stored procedure.
See books online:
mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\ods
sql.chm::/ods_6_con_00_6p9v.htm

John
[quoted text, click to view]

JHB
2/21/2004 9:25:18 PM

Hi.
I'm really new to MSSQL, so therefore my question can sound stupid.

Is it possible to use a function written in a module in MS-ACCESS in a
stored procedure?
Or how can it be done, it is a complicated function with loop and more.

I'll appreciate all answers also negatives ones.

TIA
Jørn

sql server (alternate) : Stored procedure - user defined function.