"Interesting" or general Mathematical User-defined Functions

Click For Summary
User-defined functions in MSSQL 2014 allow for custom mathematical operations, but there are concerns regarding their long-term viability. Many users advise against relying on user-defined functions due to potential complications when migrating databases to different SQL dialects in the future. The need to rewrite these functions for compatibility with other database engines can pose significant challenges. Therefore, it is recommended to stick to standard SQL practices to ensure greater flexibility and ease of future database management.
WWGD
Science Advisor
Homework Helper
Messages
7,772
Reaction score
12,992
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.
 
Technology 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 WWGD

Thread 'For those who ask: "What programming language should I learn?"'

Learn If you want to write code for Python Machine learning, AI Statistics/data analysis Scientific research Web application servers Some microcontrollers JavaScript/Node JS/TypeScript Web sites Web application servers C# Games (Unity) Consumer applications (Windows) Business applications C++ Games (Unreal Engine) Operating systems, device drivers Microcontrollers/embedded systems Consumer applications (Linux) Some more tips: Do not learn C++ (or any other dialect of C) as a...
View full post »

Similar threads

User-Defined Functions in Sql Server SSMS
  • · Replies 7 ·
Replies
7
Views
3K
What is intermediate-advanced SQL and how to learn it?
  • · Replies 6 ·
Replies
6
Views
3K
SQL Stored Procedures as Front End?
  • · Replies 4 ·
Replies
4
Views
2K
Python User-Defined Function in Python
  • · Replies 11 ·
Replies
11
Views
3K
Remembering T-SQL: SET vs SELECT and OBJECT_ID()
  • · Replies 1 ·
Replies
1
Views
1K
Embarrassingly Simple SQL Server query: List Even numbers in....
  • · Replies 7 ·
Replies
7
Views
2K
Java Searching & Displaying Items in Android App Using Java & SQL
  • · Replies 5 ·
Replies
5
Views
3K
Amateur Dev Q: Creating Front End for SQL Server DB
  • · Replies 18 ·
Replies
18
Views
4K
JavaScript Why use spread operator in this react program? What does it do?
  • · Replies 2 ·
Replies
2
Views
2K
C/C++ C++: Calling function in main.cpp from another .cpp file
  • · Replies 6 ·
Replies
6
Views
12K