21CTO

Oct 28, 2015 · Databases

Block SELECT * Queries with a One‑Line Computed Column Hack

This article explains why using SELECT * is problematic and demonstrates a simple technique—adding a computed column that triggers a divide‑by‑zero error—to block SELECT * queries while still allowing column‑specific selections.