A code review surprised me with an unusual use of the Row Constructor. Here is what the code did and how you can play with row constructors yourself.
SQL SERVER – Maintain Carriage Return (Enter Key) in SQL Server 2016 Management Studio While Copy and Paste
Copy grid results with line breaks and paste them: SQL Server 2016 Management Studio drops the carriage returns. Here is the setting that keeps them.
SQL SERVER – Puzzle – Solve Splitting Strings Puzzle
A Splitting Strings puzzle: take a column holding delimited values, split them and return how many values each row has. How would you solve it?
MySQL – ELT() and FILED() Functions to Extract Index Position From List
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 – How to Remove All Characters From a String Using T-SQL?
A reader wanted only the digits from a string like ab123ce234fe. Here is a simple T-SQL loop to remove all characters from a string and keep the numbers.
SQL SERVER – CONCAT function and NULL values
The CONCAT function and NULL values: CONCAT in SQL Server 2012 simply ignores NULL, while the + operator returns NULL. Here is a simple example.
Interview Question of the Week #008 – Write Scripts to Convert String to Title Case or Proper Case
Convert string values to title case with a corrected function, ordered SQL Server aggregation, and clear limits for personal names.