MySQL’s ELT() returns the value at a given index position in a list, and FIELD() does the reverse. Here is how both functions work, with simple examples.
SQL SERVER 2016 – STRING_SPLIT Function Performance Comparison – Notes from the Field #118
Splitting strings once meant temp tables or CROSS APPLY. In Notes from the Field #118, Kathi Kellenberger compares STRING_SPLIT performance in SQL Server 2016.
Interview Question of the Week #059 – What are the Limitations of User Defined Functions (UDF) ?
Interview Question of the Week – What are the Limitations of User Defined Functions (UDF) ? Let us learn about that in today’s blog post.
SQL SERVER – JSON Support for Transmitting Data for SQL Server 2016 – Notes from the Field #114
In Notes from the Field #114, Kathi Kellenberger explores the new SQL SERVER – JSON support in the 2016 release and how it helps you transmit data from queries.
SQL SERVER 2016 – IF EXISTS Function on SQL Azure Databases and More
Many SQL Server 2016 features reach Azure SQL Database first. Here is how I checked the IF EXISTS Function and other new features on SQL Azure databases.
SQL SERVER – Fixing Annoying Network Binding Order Error – Notes from the Field #112
Ryan Adams explains a critical SQL Server error about network binding order and shows how to fix it in this Notes from the Field episode.
Interview Question of the Week #055 – How to Convert ASCII to DECIMAL or DECIMAL to ASCII?
Interview question: how do you convert ASCII to DECIMAL or DECIMAL to ASCII in SQL Server? The answer uses two simple built-in functions.