Tag Archives: sql

SQL Server NULLIF Function

If you are like me when it comes to developing SQL solutions, you will inevitably use ISNULL function but did you know about NULLIF function. This function is almost the opposite …

Tags: , , , , , , | Posted under Programming/Coding | Leave a comment

Calculating Percent of Total in a SQL Select Statement

I am always amazed at how SQL server provides a lot of calculations and logic built right into a select statement. Most of the time (if you are like me) …

Tags: , , , , , , , , | Posted under Programming/Coding | Leave a comment

OpenCart – Massive SQL Insert

There will be times that you will be using the Opencart framework for your own web applications where the goal will not be eCommerce or having an online store. In …

Tags: , , , , , | Posted under OpenCart | Leave a comment