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 |
|
m2mthu
Starting Member
1 Post |
 Posted - 2009-05-24 : 21:56:39
|
| I have a function, but it's called more times.I want to know that the result of function will be save for the next call or it's executed every call?Thanks so much! |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-05-25 : 00:28:07
|
| How are you calling it and what does the function look like.In general functions need to be deterministic and so are executed for every call and cannot save data.Try testing it and see.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Have save the function result?