SQL JOINs make it easy to find and fix missing data Your email has been sent Many people are confused by various JOIN operations supported by SQL. Learn to master the SQL command line with this ...

Creating and using an SQLite database for data persistence in Android apps. Covers the basics, as well as using foreign keys. Full source included.

SQL Server 2008 offers two options for collecting change tracking information within the database engine, using built-in features that offer reliability and performance advantages over tracking tables ...

How to Select a Subset in MySQL. The Structured Query Language, used in the MySQL database, has great flexibility for selecting subsets of data from database tables. SQL's SELECT statement shows ...

Code Focused Deleting All Data from a SQL Server Database There are times as a developer that you will want to be able to delete all the data from a database as efficiently as possible. Unfortunately, ...

We use linked servers in SQL Server 2000 (I know...) to pump data from an AS400 running DB2 in to some tables in SQL Server to do analysis.

The functionality is also standardized in ISO/IEC 13249 SQL/MM. This paper presents part 3 of the standard and discusses it critically. The spatial data types and methods on these types are explained.