Category Archives: SQL
How to upload multiple Excel 2007 files to SQL Server 2005
If you are here, then you are probably encountering the following: SQL Server 2005 Import/Export wizard is not recognizing your Excel 2007 (xlsx) file(s) You have many files that you need to upload and can’t afford to do them one … Continue reading
Filed under Computer - Technical, SQL
Using Navicat with Kilu.de or GoDaddy MySql – Navicat und Kilu.de oder GoDaddy
A great place to get free hosting with PHP and MySQL support is kilu.de. To access MySQL they provide access through phpMyAdmin. However, if you’re a Navicat user, you like to make use of it. Here are the steps you … Continue reading
Filed under Computer - Technical, SQL
Difference between Temp Tables, Common Table Expressions and Table Variables in SQL Server
Temporary Tables Remain until they are dropped or the connection that they were created in ends Can have primary keys, constraints and indexes Reside in memory (usually) – but can end up written in tempdb Query optimizer can be used … Continue reading
Filed under SQL
