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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-01-24 : 08:37:03
|
| goli writes "Hi,I want to insert to a table within user defined function or execute a store procedure .Are any way to do this task?Thanks." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-01-24 : 08:38:10
|
| No. UDFs cannot perform permanent data modifications, nor can they execute any procedure or dynamic code except for extended stored procedures. Books Online describes these and other restrictions under the "CREATE FUNCTION" entry. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-01-24 : 08:58:37
|
| Use Stored Procedure instead of FunctionMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
execute a store procedure within user defined function