BlogHide Resteemspretentious (45)in sql • 7 years agoSQL Issue: INSERT without column_listWhen reviewing application code, I often see INSERT queries that don't specify a column list. INSERT INTO Table1pretentious (45)in sql • 7 years agoSQL Issue: Short Table AliasesI often see queries that use short names for table aliases. The queries look something like this. SELECT a.Column2pretentious (45)in sql • 7 years agoSQL Issue: Code Comments... or lack of themI was looking at a stored procedure the other day, trying to troubleshoot an issue. The stored procedure was well structured, short and relatively simple. The problem was, I didn't know what it was…pretentious (45)in sql • 7 years agoSQL Issue: SELECT INTO #TempTableWhen writing queries, we often require an intermediate table to store results which will be used later in the query. One of the more common ways to achieve this is with a temporary table. SELECT…pretentious (45)in sql • 7 years agoSQL Issues: LIKE '%stuff%'The SQL 'LIKE' operator is powerful. It allows us to do wildcard searches on column values. We love to use it, but sometimes we misuse it. I often see developers use the LIKE operator to do a…pretentious (45)in sql • 7 years agoSQL Issue: SELECT * FROM TableWhile troubleshooting an application, I stumbled across this SQL query issued by the app. SELECT *pretentious (45)in csharp • 7 years agoC# 001: Hello WorldThis is the first in a series of articles describing how to program in C#. We'll start from the very beginning and provide the building blocks for you to create more elaborate applications. To…