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.

 

Create Table in SQL Server IF it does NOT Exist
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 complete user-friendly way for testing table existence.
Importing CSV File Into SQL Server Using Bulk Insert
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.
Visual Guide to SQL Joins
24th February 2009SQL
When combining rows from multiple tables in one query, you may need to use the JOIN command. There are a few different types of joins, and the following should help explain the differences between them.