-
This post is not only about SELECT *
Read more: This post is not only about SELECT *I was about to walk out the door to take a flight, when my phone rang. Our major software system we had just released last week was returning weird data. FirstName and LastName was being reversed. I missed my flight because someone wrote SELECT * instead of SELECT FirstName, LastName and a table structure was…
-
Using TRANSLATE in SQL Server instead of REPLACE
Read more: Using TRANSLATE in SQL Server instead of REPLACESo the other day I was doing some data cleanup tasks, trying to format various values in a first name column. Needless to say, not everyone takes the task of giving a first name as sensically as you might imagine. And sense you generally don’t want to stop anyone from having any name they want.…
-
Temporary Stored Procedures in SQL Server
Read more: Temporary Stored Procedures in SQL ServerPretty much every T-SQL programmer knows about temp tables very early in their journey with the language. They are generally wonderful tools that, when used properly, can be invaluable for storing data for a short amount of time. When used improperly they can be somewhat problematic, but certainly they are a tool we all use…
-
Fun with COUNT aggregate calls
Read more: Fun with COUNT aggregate callsI was reading LinkedIn posts the other day when I saw this blog about what was apparently an interview question about some forms of a COUNT aggregate function This was apparently asked in an interview. What will each of these constructs do in a SQL statement: The correct answers the poster gave were not the…
Hello,
I’m Louis
I have been at this database thing for a long long time, with no plans to stop.
This is my blog site, companion to drsql.org
Series: SQL Techniques You Should Know
Drsql.link 