"Interesting" or general Mathematical User-defined Functions

Click For Summary
SUMMARY

User-defined functions (UDFs) in MSSQL 2014 are discouraged due to potential future compatibility issues with different SQL dialects. The discussion highlights the risks associated with using UDFs, particularly the need for rewriting these functions when migrating to another database engine. The consensus is to adhere to standard SQL practices to ensure long-term maintainability and compatibility of database systems.

PREREQUISITES
  • Understanding of MSSQL 2014 features and limitations
  • Familiarity with standard SQL syntax and practices
  • Knowledge of database migration challenges
  • Basic concepts of user-defined functions in SQL
NEXT STEPS
  • Research the implications of using user-defined functions in MSSQL 2014
  • Learn about standard SQL practices to enhance database compatibility
  • Explore database migration strategies and tools
  • Investigate alternative methods for mathematical operations in SQL without UDFs
USEFUL FOR

Database developers, database administrators, and anyone involved in SQL database design and maintenance, particularly those concerned with future-proofing their database systems.

WWGD
Science Advisor
Homework Helper
Messages
7,806
Reaction score
13,120
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   Reactions: WWGD

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
4K
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