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 |
|
wangyc77
Yak Posting Veteran
65 Posts |
 Posted - 2007-03-01 : 03:24:32
|
| I will like to choose if i should write my code using all SP or UFD as I need to chieve the following conditions1.Need to use the result of one SP(or UDF) from another SP( or UDF)2.performance is crucialmy concerns: 1.(if I use SP)I heard if i use a temp table to accept the result from another SP, recompilation of the table each time is going to affect performance greatly2.(if I use UDF) An new instance of function is created everytime it is called, so it cant really have a good performance compared to SP as SP is cached, is this statement true?Thanks**Jonathan** |
|
|
wangyc77
Yak Posting Veteran
65 Posts |
Posted - 2007-03-01 : 03:27:05
|
| This is the temp table I am talking abot when using SPhttp://searchsqlserver.techtarget.com/expert/KnowledgebaseAnswer/0,,sid87_gci1090074,00.html**Jonathan** |
 |
|
|
|
|
|
Sharing data