"Interesting" or general Mathematical User-defined Functions

Join the discussion
Registration is free. Ask a follow-up in this thread, or start your own.
1 reply · 1K views
Science Advisor
Homework Helper
Messages
7,844
Reaction score
13,167
Hi all, just curious. I am just learning about user-defined functions in MSSQL2014.
What kind of Math can we do with it? Didn't get much useful from my search.
 
Physics news on Phys.org
(shudder) My advice: Stay away from user-defined functions and anything else that is not standard SQL. Some time in the far future (say next year) somebody will require your data base to be converted to another database engine with a different SQL dialect - and then all your user-defined functions must be rewritten (or worse).
 
  • Like
Likes   Reactions: WWGD