SQL CASE: Know and Avoid 3 Lesser-Known Hassles

SQL CASE? Piece of cake!


Not until you bump into 3 troublesome issues that can cause runtime errors and slow performance.

If you are trying to scan the subheadings to see what the issues are, I can’t blame you. Readers, including me, are impatient.

I trust that you already know the basics of SQL CASE, so, I won’t bore you with long introductions. Let’s dig into a deeper understanding of what’s happening under the hood.

CodingSight - SQL CASE: Know and Avoid 3 Lesser-Known Hassles
Read More

5 No-Hassle Tips to Use SQL UPDATE Statement with JOIN

“Oops! My bad.” How many times did you say this after an SQL UPDATE had gone wrong? The thing is, if you aren’t careful, a table update can have serious consequences in the form of the DELETE statement. It could become even worse if you complicate it by using UPDATE with JOIN. That’s why you need to think it over before hitting Execute or pressing CTRL-E.

So, today you will learn how to code your SQL UPDATE with JOIN without hassles and never say “Oops! My bad” again.

Read More

Top 5 Facts to Find and Replace SQL Texts in SQL Server with REPLACE Function

Today’s code editors and word processors come with a search and replace feature. It is helpful when you need to change a word or a group of words. We don’t want to throw away our written work for a minor problem or change.

The same thing applies to our data. Users will curse us if we tell them to edit what needs to be renamed. That’s why a search and replace feature is also available to replace texts written in our databases. Here SQL REPLACE comes in.

CodingSight - SQL Replace
Read More