I regularly export table data from MySQL using PHP, however a question on StackOverflow.com came up where the user wanted to export data from MS SQL rather than MySQL.Handily, PHP has support for many of the same functions for MS SQL as it does for MySQL. So with a bit of reworking I was able [...]
Sometimes it’s necessary to format numbers as Strings with leading zero’s. One such example is when we sort a list in Excel, Excel will sort the numbers as 0,1,10,2,20,3,30,….. So, to get round this, we simply append a leading 0 to the number. This is achieved in T-SQL by using the RIGHT instruction with following [...]
I have a method here which allows you to add Parameters to the Stored Procedure from Excel. There are quite a few steps, but I’ve broken it down quite alot. The process is actually really easy once you know how... as with anything. Open Excel Select the Data Tab (If you’re using Excel 2007 onwards!) [...]