select Archives - Born SQL

Why you should not use SELECT *

by Randolph
August 8, 2018August 30, 2018

A shorter post this week, but an important one. Last week, Erik Darling commented on my post saying that we shouldn’t use SELECT *, which was both amusing and accurate. Amusing, because a number of… Why you should not use SELECT *

How to write a SELECT query

by Randolph
May 24, 2017May 12, 2017

My First SELECT Statement Microsoft SQL Server makes it really easy for us to query tables. In SQL Server Management Studio (SSMS) for instance, we can right-click on any table we have access to and… How to write a SELECT query