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.
| Author |
Topic |
|
mapidea
Posting Yak Master
124 Posts |
 Posted - 2009-02-07 : 02:25:19
|
| Can we call a stored procedure from a function and vice versa?Thanks. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-02-07 : 03:23:22
|
You can, but's it hard and involves creating a linked server to self, a "loopback" connector.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
mapidea
Posting Yak Master
124 Posts |
Posted - 2009-02-07 : 04:17:09
|
| Thanks for your reply. Do we have a link explaining that? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-07 : 08:16:18
|
| why do you want to do that? what does procedure do? |
|
|
|
mapidea
Posting Yak Master
124 Posts |
Posted - 2009-02-11 : 01:23:58
|
| I was checking if we can do this. To call a stored procedure from a function we need to write extended stored procedure in C++. |
|
|
|
|
|
|
SP from Function