pretentious (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…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.…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…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…
