Why I Never Use SELECT * FROM

I’ve heard for many years that using SELECT * FROM <some table> is a bad idea.  I’ve always agreed with this in principle, but in practice often haven’t followed this guideline.  That’s all about to change, as I was caught out by what (in my opinion) is a bug in Microsoft SQL Server that totally… Continue reading Why I Never Use SELECT * FROM

Published
Categorized as SQL

Excel with Stored Procedures

Introduction A couple of week ago, I read this post by David Poole about reading data from SQL Server into Excel, where the data source was a parameterised stored procedure.  David concludes that a small amount of (albeit trivial) VBA code is required in order to make this work.  However, deep down in my psyche,… Continue reading Excel with Stored Procedures

Published
Categorized as SQL