468,771 Members | 1,877 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,771 developers. It's quick & easy.

Stored procedure - user defined function.

JHB
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

Jul 20 '05 #1
1 3040
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%2 0Server\80\Tools\Books\ods
sql.chm::/ods_6_con_00_6p9v.htm

John
"JHB" <jo*******@removedettetdcadsl.dk> wrote in message
news:40***********************@dread15.news.tele.d k...
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

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Steen Andreassen | last post: by
5 posts views Thread by Tim Marshall | last post: by
3 posts views Thread by Bilbo | last post: by
10 posts views Thread by John Bailo | last post: by
reply views Thread by SOI_0152 | last post: by
1 post views Thread by CARIGAR | last post: by
1 post views Thread by Marin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.