I recently wrote a .NET web application for work. I always make a data access class with methods for getting data, but I usually just point the methods to stored procedures. This time, I decided to ...
A while ago somebody posted in one of my threads six or so reasons to use stored procedures instead of raw SQL in asp applications. I know a couple of reasons, but a few of the reasons he listed I ...
A common SQL habit is to use SELECT * on a query, because it’s tedious to list all the columns you need. Plus, sometimes those columns may change over time, so why not just do things the easy way? But ...