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.

How to Disable CLR Strict Security on SQL Server 2017+
SQL
How to Disable CLR Strict Security on SQL Server 2017+

New configuration option in SQL Server 2017 called CLR strict security, enabled by default, causes problems when using CLR.
- 21st Apr, 2017

CREATE TABLE IF NOT EXISTS equivalent in SQL Server
SQL
CREATE TABLE IF NOT EXISTS equivalent in SQL Server

How to use CREATE TABLE IF NOT EXISTS in SQL Server which does not provide a complete user-friendly way for testing table existence.
- 1st May, 2011

Importing CSV File Into SQL Server Using Bulk Insert
SQL
Importing CSV File Into SQL Server Using Bulk Insert

Importing CSV File data into SQL Server table is a commonly asked question that has an easy answer. Find out how to use SQL Bulk Insert.
- 15th Mar, 2010

Visual Guide to SQL Joins
SQL
Visual Guide to SQL Joins

This visual guide to SQL joins should help you determine which one of the various SQL join types to use for the query you need to run.
- 24th Feb, 2009