"Interesting" or general Mathematical User-defined Functions

1 reply · 1K views · last reply
Science Advisor
Homework Helper
Messages
7,927
Reaction score
13,242
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.
 
(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