MySQL Insert Command vs T-SQL Query Syntax with Examples
Developers are lifelong students. Gaining new knowledge as fast as we can is always our gig. If...
How to Round (UP/DOWN) in SQL Server – 5 Useful Tips
We’ve been taught to round numbers since we were kids. When you round off 1.15 to the nearest tenths, will it be 1.2 or 1.1? Using the...
CREATE TABLE MySQL vs T-SQL with Syntax Examples
Are you a T-SQL developer learning the basics of MySQL? Then, one of the things you might want to learn is MySQL CREATE TABLE statement....
SQL UNION Cheat Sheet with 10 Easy and Useful Tips
Having a hard time with SQL UNION? It happens if the results you combined put your SQL Server into...
Do You Make These Mistakes When Using SQL CURSOR?
For some people, it’s the wrong question. SQL CURSOR IS the mistake. The devil is in the details! You can read all sorts of...
How to Parse Strings Like a Pro Using SQL SUBSTRING() Function?
Do you enjoy parsing strings? If so, one of the indispensable string functions to use is SQL SUBSTRING. It is one of those skills a...
Your Ultimate Guide to SQL Join: CROSS JOIN – Part 3
CROSS JOIN is in the spotlight. This article finishes our small series of SQL JOIN-related...
Top 3 Tips You Need to Know to Write Faster SQL Views
Friend or foe? SQL Server views have been a subject of heated debates when I was in my first year using SQL Server. They said it was bad...
Your Ultimate Guide to SQL Joins: OUTER JOIN – Part 2
Outer join is at the center stage today. And this is part 2 of your ultimate guide to SQL joins. If you missed part 1, here’s the...
Your Ultimate Guide to SQL Join: INNER JOIN – Part 1
Inner join, outer join, cross join? What gives? It’s a valid question. I once saw a Visual Basic...
