3 ms·
> The problem with this theory is programming in some databases (MS SQL Server) is extremely unpleasant. Oh forget about string splitting and the like. The lan
by anton_gogolev 10y ago
> The problem with this theory is programming in some databases (MS SQL Server) is extremely unpleasant.
Oh forget about string splitting and the like. The language itself (T-SQL and SQL in general) is a disaster. No modularization possibilities (wanna do a this particular "SELECT" but with slightly different something? well, copy-paste the whole thing), sensible code autocompletion is next to impossible (type "SELECT _" wat? from wat?), don't get me started on type conversions, dumbest possible error messages, the "IN (@multipleValues)" disaster, and oh my.
- michaelmior 10y agoI'm not saying this is ideal, but there are certainly possibilities for modularization. You can create views that cover cimmin query predicates and then write queries against those views.
- michaelmior 10y agos/cimmin/common/g