Website development and design blog, tutorials and inspiration

SQL

Database programming tutorials for MySql and Microsoft SQL Server, with tips on performance optimisation and how to use the data in PHP, C#, ASP.Net and JavaScript.

 

1st May 2011SQL
There are many reasons to create a table using a script, and a quick check if the table already exists will eliminate problematic errors, however Microsoft SQL Server does not provide a completely user friendly way for testing table existence.
15th March 2010SQL
How to import CSV file into SQL Server or how to load CSV file into SQL Server table are two commonly asked questions that have an easy answer.