| Author: ABitSmart 06 Nov 2009 | Member Level: Diamond | Rating:  Points: 2 |
No, you cannot.
Kind regards,
ABitSmart
DNS Web-master, DNS MVM
My blog
Thoughts.exe
|
| Author: pradeep kumar reddy 06 Nov 2009 | Member Level: Silver | Rating: Points: 2 |
hi
function and stored procedure are similar except some small differences.
we cannot call a stored procedure inside a function
|
| Author: Hari 06 Nov 2009 | Member Level: Gold | Rating: Points: 2 |
Inside a function you can not modify data and can not execute stored procedure. that's because the servers needs to assume that the state of the DB and data will not change by calling the function (again, by design because the server would basically need to recompile the queries after each call to the function... which happens on every rows in the select). If you need to do such modifications, it needs to be done inside a proc.
|
| Author: Nikhil Gaur 06 Nov 2009 | Member Level: Diamond | Rating: Points: 2 |
I can't understand why all are saying that we can not call stored procedure through function. It is possible. Yes, you can call it through function. find how here
http://www.dreamincode.net/forums/showtopic79651.htm
Join this campus group
http://www.dotnetspider.com/sites/637/-ecb-aspdotnet.aspx
Thanks & Regards
NIks
My Software and Web Development Experience
|
| Author: ABitSmart 08 Nov 2009 | Member Level: Diamond | Rating: Points: 2 |
Nikhil Gaur, This is an SQL question. You cannot call an SQL Stored procedure from SQL function. You are confused. The link has no relation to the question.
Kind regards,
ABitSmart
DNS Web-master, DNS MVM
My blog
Thoughts.exe
|
| Author: Bunty 09 Nov 2009 | Member Level: Diamond | Rating: Points: 2 |
Hi,
No, you cannot call a stored procedure from a function but you can call a function from a stored procedure.
Thanks & Regards
S.S.Bajoria
|