"Interesting" or general Mathematical User-defined Functions

Join the discussion
Ask a follow-up here, or get your own question answered by working scientists, mathematicians and engineers — people, not an autocomplete.
Real named experts · corrections over time · the nuance an AI answer skips
1 reply · 1K views
Messages
7,822
Reaction score
13,151
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