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...
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 you’re coming from the T-SQL camp,...
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...
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 a standstill. Or a report that’s been...
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...
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 publications. If you missed the previous two...
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...
