SQL Joins using Geographic Data
In this post we illustrate SQL joins using a common example of geographic data in a Microsoft Access […]
Blog
Java Programming Language
The Java website says: “Java is a programming language and computing platform first released by Sun Microsystems in […]
SQL Server Insert Into Select Part 2
This post shows you how to insert data into an existing empty table from two other tables using […]
Triple Bottom Line
The Economist in an article said the following: “The phrase “the triple bottom line” was first coined in […]
SQL Server Changing Table Structure
The table structure refers to the columns in the table. We can use T-SQL to add a new […]
SQL Server Union Sorted
This post discusses how you can take a table with a single column of data and add a […]
SQL Server GUID
In SQL Server we can use GUIDs. A GUID is a 128 bit number to identify objects. It […]
Globally Unique Identifier (GUID)
What is a GUID? GUIDs are large, enormous numbers that are usually 128 bits long and look like […]
SQL Server Sequence
What is sequence? SQL Server sequences allow you to store a sequence of numbers. You are in control […]
SQL Server Sequential Numbers Part 4
Our query will create sequence numbers. This is part 4. We other posts called SQL Server Sequential Numbers […]
SQL Server Exception Handling Part 14
This post is a continuation of our SQL Server project that uses exception handling, except that here we […]
SQL Server Finding String Length
Suppose you have a table with a column that needs some data validation performed on it. The data […]